trees

37 rows where qSpecies_id = 210

✎ View and edit SQL

This data as json, CSV (advanced)

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)
1989 210578 DPW Maintained 1 Nerium oleander :: Oleander 210 1035 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     40 Width 3ft   6000825.31022 2096196.70689 37.7358032894806 -122.439599180256 (37.7358032894806, -122.439599180256) 2 7 5 63 7
5782 139851 DPW Maintained 1 Nerium oleander :: Oleander 210 745 GOUGH ST 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6005737.8288 2112306.3675 37.780315026191 -122.423759752344 (37.780315026191, -122.423759752344) 7 9 11 28852 41
14563 61079 DPW Maintained 1 Nerium oleander :: Oleander 210 2605 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/01/1983 12:00:00 AM 4   Permit Number 20916 5999614.0204 2113612.0437 37.7835524809627 -122.445038661991 (37.7835524809627, -122.445038661991) 15 6 1 29490 31
25010 187537 DPW Maintained 1 Nerium oleander :: Oleander 210 38 Megan Dr 1 : Tree Private 2     3 Width 1ft   6012599.06597 2088003.21705 37.7139687160564 -122.398317717311 (37.7139687160564, -122.398317717311) 10 3 8 309 1
26522 118195 DPW Maintained 1 Nerium oleander :: Oleander 210 858 35th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5985129.69457 2110010.45788 37.7728262247758 -122.494882469642 (37.7728262247758, -122.494882469642) 11 6 2 55 26
27416 131775 DPW Maintained 1 Nerium oleander :: Oleander 210 575 Ellis St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008072.74326 2113748.53186 37.7844063922968 -122.415784324012 (37.7844063922968, -122.415784324012) 7 10 9 28858 36
36763 194108 DPW Maintained 1 Nerium oleander :: Oleander 210 368 Texas St 1 : Tree Private 2     10 Width 3ft   6013743.33639 2105379.84222 37.7617449983419 -122.395579361707 (37.7617449983419, -122.395579361707) 10 3 8 28856 29
39512 177852 DPW Maintained 1 Nerium oleander :: Oleander 210 521 Lisbon St 2 Sidewalk: Curb side : Yard Tree Private 2     22 Width 6ft   6002035.79624 2090425.67682 37.7200261725498 -122.43500145298 (37.7200261725498, -122.43500145298) 9 7 6 28861 5
40588 256154 Undocumented 4 Nerium oleander :: Oleander 210 80X Peralta Ave 3 Median : Cutout Tree Private 2       3x3   6010428 2100359 37.747773912222 -122.406691992098 (37.747773912222, -122.406691992098) 2 7 7 28859 2
41683 232428 DPW Maintained 1 Nerium oleander :: Oleander 210 3590 21st St 6 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6004408.04732 2103685.00061 37.756567678684 -122.427745630074 (37.756567678684, -122.427745630074) 2 4 5 28862 3
47882 232426 DPW Maintained 1 Nerium oleander :: Oleander 210 3590 21st St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6004444.4891 2103684.24986 37.7565676786584 -122.427619547826 (37.7565676786584, -122.427619547826) 2 4 5 28862 3
52813 131773 DPW Maintained 1 Nerium oleander :: Oleander 210 1920 Beach St 9 Sidewalk: Property side : Yard Tree Private 2     12 Width 6ft   6000974.22236 2121019.17087 37.803968053338 -122.440864429257 (37.803968053338, -122.440864429257) 13 9 1 57 17
56022 232420 DPW Maintained 1 Nerium oleander :: Oleander 210 4443 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6001073.94489 2101115.72493 37.7493239003969 -122.43909199051 (37.7493239003969, -122.43909199051) 2 4 5 28862 22
71812 187539 DPW Maintained 1 Nerium oleander :: Oleander 210 18 Megan Dr 1 : Tree Private 2     3 Width 1ft   6012576.27604 2088054.60024 37.7141085345515 -122.398400091593 (37.7141085345515, -122.398400091593) 10 3 8 309 1
76164 194104 DPW Maintained 1 Nerium oleander :: Oleander 210 801 19th St 2 Sidewalk: Curb side : Yard Tree Private 2     3     6015143.45963 2105289.88586 37.7615757783253 -122.390730569759 (37.7615757783253, -122.390730569759) 10 3 8 28856 29
77312 232427 DPW Maintained 1 Nerium oleander :: Oleander 210 3590 21st St 5 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6004428.1089 2103685.4949 37.7565701707031 -122.427676285143 (37.7565701707031, -122.427676285143) 2 4 5 28862 3
78690 187519 DPW Maintained 1 Nerium oleander :: Oleander 210 228 Lauren Ct 1 : Tree Private 2     2 Width 1ft   6012451.94839 2088119.46393 37.7142797106237 -122.398834367924 (37.7142797106237, -122.398834367924) 10 3 8 309 1
79449 194106 DPW Maintained 1 Nerium oleander :: Oleander 210 535 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6014415.94841 2104620.80812 37.7596982456973 -122.393199933626 (37.7596982456973, -122.393199933626) 10 3 8 28856 29
85705 57113 DPW Maintained 1 Nerium oleander :: Oleander 210 531 London St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1974 12:00:00 AM 8   Permit Number 14383 6001543.07582 2090663.01106 37.7206498496809 -122.436721596137 (37.7206498496809, -122.436721596137) 9 7 6 28861 5
95884 92432 Permitted Site 7 Nerium oleander :: Oleander 210 534 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/30/2009 12:00:00 AM   3x3 Permit Number 52822 6010140 2111945 37.779570317084 -122.408505034297 (37.779570317084, -122.408505034297) 14 2 9 28853 34
102393 131774 DPW Maintained 1 Nerium oleander :: Oleander 210 1920 Beach St 10 Sidewalk: Property side : Yard Tree Private 2     11 Width 6ft   6000970.69286 2121018.51466 37.8039660505477 -122.440876596189 (37.8039660505477, -122.440876596189) 13 9 1 57 17
104759 114309 Undocumented 4 Nerium oleander :: Oleander 210 595 ELLIS ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008020 2113749 37.7844047125189 -122.415966831143 (37.7844047125189, -122.415966831143) 7 10 9 28858 36
106776 131772 DPW Maintained 1 Nerium oleander :: Oleander 210 1920 Beach St 5 Sidewalk: Property side : Yard Tree Private 2     9 Width 6ft   6001006.99118 2121024.03439 37.8039832734622 -122.440751379974 (37.8039832734622, -122.440751379974) 13 9 1 57 17
112213 232422 DPW Maintained 1 Nerium oleander :: Oleander 210 4412 23rd St 7 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   6000503.77394 2102296.85411 37.7525345367475 -122.441148378505 (37.7525345367475, -122.441148378505) 2 4 5 28862 22
120497 131771 DPW Maintained 1 Nerium oleander :: Oleander 210 3161 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6002800.51817 2119461.63557 37.7997953114739 -122.434432992409 (37.7997953114739, -122.434432992409) 13 9 1 57 17
121707 187534 DPW Maintained 1 Nerium oleander :: Oleander 210 96 Megan Dr 1 : Tree Private 2     1 Width 4ft   6012629.72487 2087860.66126 37.7135789939572 -122.398201752406 (37.7135789939572, -122.398201752406) 10 3 8 309 1
136400 194107 DPW Maintained 1 Nerium oleander :: Oleander 210 1447 20th St 1 : Tree Private 2     8 Width 1ft   6013582.38331 2104737.66515 37.7599727664564 -122.396091031903 (37.7599727664564, -122.396091031903) 10 3 8 28856 29
138298 232419 DPW Maintained 1 Nerium oleander :: Oleander 210 629 York St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6009868.93868 2105140.11891 37.7608705020782 -122.408962494142 (37.7608705020782, -122.408962494142) 2 4 8 28859 19
142862 9743 Permitted Site 7 Nerium oleander :: Oleander 210 715 Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4   6005764.58972 2112125.49721 37.7798199112352 -122.423654310333 (37.7798199112352, -122.423654310333) 7 9 11 28852 41
147766 139856 DPW Maintained 1 Nerium oleander :: Oleander 210 715 GOUGH ST 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6005763.0211 2112117.0353 37.7797965883541 -122.42365913508 (37.7797965883541, -122.42365913508) 7 9 11 28852 41
158731 131770 DPW Maintained 1 Nerium oleander :: Oleander 210 3161 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6002794.72228 2119491.9933 37.7998783368826 -122.434455220044 (37.7998783368826, -122.434455220044) 13 9 1 57 17
164156 194105 DPW Maintained 1 Nerium oleander :: Oleander 210 545 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6014417.7827 2104595.32434 37.7596283746557 -122.393191806467 (37.7596283746557, -122.393191806467) 10 3 8 28856 29
164617 187540 DPW Maintained 1 Nerium oleander :: Oleander 210 2 Megan Dr 1 : Tree Private 2     3 Width 1ft   6012559.1048 2088097.80511 37.7142262099584 -122.39846247216 (37.7142262099584, -122.39846247216) 10 3 8 309 1
170270 9762 DPW Maintained 1 Nerium oleander :: Oleander 210 745 Gough St 4 Sidewalk: Curb side : Cutout Tree DPW 1     4 4x4   6005306.03378 2112177.46067 37.7799366952092 -122.425244357372 (37.7799366952092, -122.425244357372) 7 9 11 28852 41
175818 232421 DPW Maintained 1 Nerium oleander :: Oleander 210 4412 23rd St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6000516.95294 2102297.95962 37.7525383228891 -122.441102882707 (37.7525383228891, -122.441102882707) 2 4 5 28862 22
190257 118194 DPW Maintained 1 Nerium oleander :: Oleander 210 858 35th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5985130.26203 2110017.353 37.7728451900293 -122.494881015244 (37.7728451900293, -122.494881015244) 11 6 2 55 26
193135 187518 DPW Maintained 1 Nerium oleander :: Oleander 210 238 Lauren Ct 1 : Tree Private 2     2 Width 1ft   6012469.15492 2088126.39797 37.7142997088453 -122.398775381376 (37.7142997088453, -122.398775381376) 10 3 8 309 1

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)
);