Viewing Query

edit description
GIS

Q&A for cartographers, geographers and GIS professionals

Database Schema expand collapse
  • Posts
    Id
    int
    PostTypeId
    tinyint
    AcceptedAnswerId
    int
    ParentId
    int
    CreationDate
    datetime
    Score
    int
    ViewCount
    int
    Body
    nvarchar (max)
    OwnerUserId
    int
    OwnerDisplayName
    nvarchar (40)
    LastEditorUserId
    int
    LastEditorDisplayName
    nvarchar (40)
    LastEditDate
    datetime
    LastActivityDate
    datetime
    Title
    nvarchar (250)
    Tags
    nvarchar (150)
    AnswerCount
    int
    CommentCount
    int
    FavoriteCount
    int
    ClosedDate
    datetime
    CommunityOwnedDate
    datetime
  • Users
    Id
    int
    Reputation
    int
    CreationDate
    datetime
    DisplayName
    nvarchar (40)
    LastAccessDate
    datetime
    WebsiteUrl
    nvarchar (200)
    Location
    nvarchar (100)
    AboutMe
    nvarchar (max)
    Views
    int
    UpVotes
    int
    DownVotes
    int
    EmailHash
    varchar (32)
    Age
    int
  • Comments
    Id
    int
    PostId
    int
    Score
    int
    Text
    nvarchar (600)
    CreationDate
    datetime
    UserDisplayName
    nvarchar (30)
    UserId
    int
  • Badges
    Id
    int
    UserId
    int
    Name
    nvarchar (50)
    Date
    datetime
  • PostFeedback
    Id
    int
    PostId
    int
    IsAnonymous
    bit
    VoteTypeId
    tinyint
    CreationDate
    datetime
  • PostHistory
    Id
    int
    PostHistoryTypeId
    tinyint
    PostId
    int
    RevisionGUID
    uniqueidentifier
    CreationDate
    datetime
    UserId
    int
    UserDisplayName
    nvarchar (40)
    Comment
    nvarchar (400)
    Text
    nvarchar (max)
  • PostHistoryTypes
    Id
    tinyint
    Name
    nvarchar (50)
  • PostTags
    PostId
    int
    TagId
    int
  • PostTypes
    Id
    tinyint
    Name
    nvarchar (50)
  • SuggestedEdits
    Id
    int
    PostId
    int
    CreationDate
    datetime
    ApprovalDate
    datetime
    RejectionDate
    datetime
    OwnerUserId
    int
    Comment
    nvarchar (800)
    Text
    nvarchar (max)
    Title
    nvarchar (250)
    Tags
    nvarchar (150)
    RevisionGUID
    uniqueidentifier
  • SuggestedEditVotes
    Id
    int
    SuggestedEditId
    int
    UserId
    int
    VoteTypeId
    tinyint
    CreationDate
    datetime
    TargetUserId
    int
    TargetRepChange
    int
  • Tags
    Id
    int
    TagName
    nvarchar (25)
    Count
    int
  • TagSynonyms
    Id
    int
    SourceTagName
    nvarchar (25)
    TargetTagName
    nvarchar (25)
    CreationDate
    datetime
    OwnerUserId
    int
    AutoRenameCount
    int
    LastAutoRename
    datetime
    Score
    int
    ApprovedByUserId
    int
    ApprovalDate
    datetime
  • Votes
    Id
    int
    PostId
    int
    VoteTypeId
    tinyint
    UserId
    int
    CreationDate
    datetime
    BountyAmount
    int
  • VoteTypes
    Id
    tinyint
    Name
    nvarchar (50)
Revisions
  • Waiting for you to make your first edit…

Enter Parameters

Options:
loadingHold tight while we fetch your results
Results Messages Graph Execution Plan
Download CSV Download XML
:records rows returned in :time ms:cached