28 rows where SiteOrder = 7 and qLegalStatus_id = 2 sorted by TreeID

View and edit SQL

SiteOrder

rowid TreeID ▼ qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
126344 109462 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 7 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4 Permit Number 773752 6013376.015 2109435.75899 37.7728612052211 -122.3971341969 (37.7728612052211, -122.3971341969) 14 2 9 310 20
116898 115354 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014804.62773 2114662.16926 37.7872911737029 -122.39255807669 (37.7872911737029, -122.39255807669) 6 2 9 28855 6
75283 118380 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 7 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
102091 121512 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 7 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
52894 121531 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 7 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
139844 121546 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 7 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
113221 122425 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 7 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
34241 122599 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
41331 14313 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2190X Market St 7 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2018 12:00:00 AM 3 4x4 Permit Number 782146 6003603.86 2107219.9092 37.7662281664546 -122.430779049243 (37.7662281664546, -122.430779049243) 7 4 5 28862 3
83479 17757 Planning Code 138.1 required 2 Eucalyptus sideroxylon :: Red Ironbark 127 1634 Pine St 7 Sidewalk: Curb side : Cutout Tree DPW 1   08/01/2016 12:00:00 AM 3 3x3 Permit Number 773331 6005917.49192 2115584.99362 37.7893274652545 -122.423371354677 (37.7893274652545, -122.423371354677) 13 9 1 28858 41
149325 187946 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 7 Sidewalk: Curb side : Yard Tree Private 2     3     6015145.56326 2115239.56325 37.7888954931699 -122.391418882079 (37.7888954931699, -122.391418882079) 6 2 9 28855 6
59194 198587 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013654.04555 2107139.63113 37.7665720240075 -122.396011512024 (37.7665720240075, -122.396011512024) 14 3 8 28856 20
134197 201699 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 342 08th St 7 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6010014.86815 2109861.25987 37.7738418457656 -122.408790872027 (37.7738418457656, -122.408790872027) 8 2 9 28853 34
50671 203206 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 7 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013175.33077 2107284.78304 37.7669439332411 -122.397677495329 (37.7669439332411, -122.397677495329) 14 3 8 28856 20
3779 231240 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2000 Bryant St 7 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009523.77815 2105243.21899 37.7611342507514 -122.410163536041 (37.7611342507514, -122.410163536041) 2 4 7 28859 19
115253 251524 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
35262 253489 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 7 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
31968 253741 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 7 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
48111 253753 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 7 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
131987 254722 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
179705 255411 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 7 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
134827 255697 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 7 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2018 12:00:00 AM 3 3x3   6012573 2109637 37.773369031352 -122.399926071367 (37.773369031352, -122.399926071367) 14 2 9 28853 34
176698 256681 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 330 Twin Peaks Blvd 7 Front Yard : Yard Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
3329 260429 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
9333 261584 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 496 Urbano Dr 7 Sidewalk: Property side : Yard Tree Private 2       3x3   5992575 2091875 37.7234639294961 -122.467809264789 (37.7234639294961, -122.467809264789) 9 8 4 59 40
7258 262001 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607X Florida St 7 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009282 2105415 37.7615923672124 -122.411011879772 (37.7615923672124, -122.411011879772) 2 4 7 28859 19
145930 44005 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 2701X 17th St 7 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
119022 60277 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2690 Harrison St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/03/2008 12:00:00 AM   3x3 Permit Number 51145 6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);