Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
137994 | 137994 | 196067 | Undocumented 2 | Prunus spp :: Cherry 84 | 2338 Lane St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 5ft | 6013920.54146 | 2092873.2671400001 | 37.727414427818395 | -122.394090896496 | (37.7274144278184, -122.394090896496) | |||
138241 | 138241 | 237594 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 37 Seward St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 3ft | 6000962.1319699995 | 2104249.24086 | 37.757921415553604 | -122.439703261523 | (37.7579214155536, -122.439703261523) | |||
143868 | 143868 | 99827 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 2398 Broadway | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
146477 | 146477 | 250150 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2501 Lyon St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999218.59352 | 2117421.61343 | 37.7939899817095 | -122.446680871938 | (37.7939899817095, -122.446680871938) | ||||
147471 | 147471 | 213666 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 3ft | 5994837.41528 | 2098931.7185400003 | 37.742970331311795 | -122.460499654841 | (37.7429703313118, -122.460499654841) | |||
150089 | 150089 | 249642 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2460 Lyon St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 5999289.16084 | 2117209.34278 | 37.793411173535105 | -122.446421424722 | (37.7934111735351, -122.446421424722) | ||||
151012 | 151012 | 196294 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012397.7351 | 2104775.9114900003 | 37.7600117988112 | -122.400190869313 | (37.7600117988112, -122.400190869313) | ||||
151158 | 151158 | 249665 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2401 Lyon St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5999244.57563 | 2117118.96584 | 37.7931604758161 | -122.44656918693998 | (37.7931604758161, -122.44656918694) | ||||
151464 | 151464 | 235817 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1100 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004822.42973 | 2096709.04499 | 37.7374367425214 | -122.425816018614 | (37.7374367425214, -122.425816018614) | ||||
151507 | 151507 | 196348 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6011983.2298099995 | 2105140.07548 | 37.7609885911574 | -122.401650048127 | (37.7609885911574, -122.401650048127) | ||||
152517 | 152517 | 196065 | Undocumented 2 | Prunus spp :: Cherry 84 | 602 Arthur Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015745.278940001 | 2099859.59173 | 37.7466987082831 | -122.388270101098 | (37.7466987082831, -122.388270101098) | ||||
153540 | 153540 | 196078 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1301 Minnesota St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015385.56179 | 2102265.48112 | 37.7532848375261 | -122.389681986358 | (37.7532848375261, -122.389681986358) | ||||
155612 | 155612 | 249707 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 2400 Baker St | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999697.96101 | 2117191.03981 | 37.793384258626205 | -122.445005634599 | (37.7933842586262, -122.445005634599) | ||||
155630 | 155630 | 196373 | Undocumented 2 | Prunus spp :: Cherry 84 | 1900 19th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6012066.64129 | 2105141.25616 | 37.760996487210996 | -122.40136164543101 | (37.760996487211, -122.401361645431) | ||||
156414 | 156414 | 213668 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 3ft | 5994864.53372 | 2098940.09364 | 37.742994887300895 | -122.460406494088 | (37.7429948873009, -122.460406494088) | |||
156622 | 156622 | 135832 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6008638.145690001 | 2119013.6558 | 37.7988949039377 | -122.414200856206 | (37.7988949039377, -122.414200856206) | ||||
157981 | 157981 | 196355 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011948.055430001 | 2105132.5844400004 | 37.7609660595651 | -122.401771175125 | (37.7609660595651, -122.401771175125) | ||||
159690 | 159690 | 249982 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 224 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6011639.74764 | 2120113.25639 | 37.8020822820333 | -122.403891687471 | (37.8020822820333, -122.403891687471) | |||
160246 | 160246 | 237862 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1000 San Jose Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005165.80079 | 2097273.24395 | 37.7390053040631 | -122.424668946839 | (37.7390053040631, -122.424668946839) | ||||
161376 | 161376 | 196354 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6011952.75605 | 2105133.25565 | 37.760968164877795 | -122.40175496482 | (37.7609681648778, -122.40175496482) | ||||
161815 | 161815 | 196342 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015828.19689 | 2099862.61894 | 37.7467116144672 | -122.38798358786501 | (37.7467116144672, -122.387983587865) | ||||
162343 | 162343 | 237863 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1100 San Jose Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004816.92245 | 2096702.3480099998 | 37.737418042901204 | -122.42583458331801 | (37.7374180429012, -122.425834583318) | ||||
162715 | 162715 | 235819 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1100 San Jose Ave | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6004808.19427 | 2096683.55845 | 37.7373659577613 | -122.42586342366 | (37.7373659577613, -122.42586342366) | ||||
164608 | 164608 | 135833 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008637.50385 | 2119009.84925 | 37.798884416044295 | -122.414202807733 | (37.7988844160443, -122.414202807733) | ||||
165936 | 165936 | 249667 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2401 Lyon St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5999247.612269999 | 2117079.36111 | 37.7930519051704 | -122.446555829313 | (37.7930519051704, -122.446555829313) | ||||
168699 | 168699 | 247958 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010403.29697 | 2098902.73698 | 37.7437739492996 | -122.406674804102 | (37.7437739492996, -122.406674804102) | ||||
170177 | 170177 | 135830 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008645.65329 | 2119014.61059 | 37.7988979472514 | -122.41417494494101 | (37.7988979472514, -122.414174944941) | ||||
170863 | 170863 | 236791 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 192 Marview Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 0ft | 5998125.74661 | 2103459.41933 | 37.755590911501606 | -122.44945572381799 | (37.7555909115016, -122.449455723818) | |||
171242 | 171242 | 249941 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 331 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6011275.707669999 | 2120025.2952 | 37.8018204174494 | -122.40514524887199 | (37.8018204174494, -122.405145248872) | |||
171682 | 171682 | 135825 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 941 Vallejo St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6008892.44244 | 2118672.21795 | 37.7979716806151 | -122.413296744356 | (37.7979716806151, -122.413296744356) | ||||
172165 | 172165 | 135823 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1015 Vallejo St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6008630.162959999 | 2118635.32656 | 37.7978556572789 | -122.414201697946 | (37.7978556572789, -122.414201697946) | ||||
173495 | 173495 | 249974 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 28 Napier Ln | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 0ft | 6011652.50252 | 2120258.9240099997 | 37.802482962378704 | -122.403857805517 | (37.8024829623787, -122.403857805517) | |||
174122 | 174122 | 196290 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012385.57921 | 2104781.3261 | 37.760025988325296 | -122.400233291241 | (37.7600259883253, -122.400233291241) | ||||
174273 | 174273 | 196356 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6011943.684880001 | 2105131.53346 | 37.760962929905894 | -122.40178621716001 | (37.7609629299059, -122.40178621716) | ||||
174515 | 174515 | 236750 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3943 21st St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6002208.02955 | 2103519.5484700003 | 37.7559886915345 | -122.43534223396601 | (37.7559886915345, -122.435342233966) | ||||
175316 | 175316 | 235818 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1100 San Jose Ave | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6004748.03107 | 2096617.2038599998 | 37.7371803628754 | -122.426066713609 | (37.7371803628754, -122.426066713609) | ||||
175538 | 175538 | 196115 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1900 19th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012049.31066 | 2105149.60429 | 37.7610184423716 | -122.401422171593 | (37.7610184423716, -122.401422171593) | ||||
176516 | 176516 | 235822 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Eugenia Ave | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6006569.74565 | 2098123.14893 | 37.7414181446448 | -122.419875033313 | (37.7414181446448, -122.419875033313) | ||||
177400 | 177400 | 250146 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2501 Lyon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5999207.44391 | 2117490.79429 | 37.79417929707979 | -122.446724430609 | (37.7941792970798, -122.446724430609) | ||||
177422 | 177422 | 237963 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1000 San Jose Ave | 106 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6005052.98208 | 2096959.6805599998 | 37.7381379574049 | -122.42503671826799 | (37.7381379574049, -122.425036718268) | ||||
177555 | 177555 | 135829 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008653.20032 | 2119016.0444 | 37.798902308044205 | -122.414148931139 | (37.7989023080442, -122.414148931139) | ||||
179258 | 179258 | 196339 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 8ft | 6015967.11689 | 2099936.1121799997 | 37.7469211070262 | -122.387508338452 | (37.7469211070262, -122.387508338452) | |||
182162 | 182162 | 249963 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 271 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6011592.60874 | 2120072.38059 | 37.8019674134157 | -122.404051933175 | (37.8019674134157, -122.404051933175) | |||
183588 | 183588 | 196335 | Undocumented 2 | Prunus spp :: Cherry 84 | 1900 19th St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6012008.47004 | 2105145.92381 | 37.761006057794 | -122.401563163706 | (37.761006057794, -122.401563163706) | ||||
183745 | 183745 | 196351 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6011965.48 | 2105145.22305 | 37.7610017347515 | -122.40171179916901 | (37.7610017347515, -122.401711799169) | ||||
184038 | 184038 | 249689 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2400 Baker St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999718.81935 | 2117298.99939 | 37.7936818775552 | -122.444941227873 | (37.7936818775552, -122.444941227873) | ||||
184115 | 184115 | 249937 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 339 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011248.56733 | 2120031.66705 | 37.8018363956996 | -122.405239616532 | (37.8018363956996, -122.405239616532) | |||
185940 | 185940 | 196285 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2209 25th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6012134.59471 | 2101859.1570900003 | 37.7519883551004 | -122.400896021442 | (37.7519883551004, -122.400896021442) | ||||
186723 | 186723 | 196338 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6015971.97004 | 2099951.82403 | 37.7469645173129 | -122.387492652478 | (37.7469645173129, -122.387492652478) | ||||
187204 | 187204 | 237951 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 200 Eugenia Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6006574.718780001 | 2098103.54318 | 37.7413645918137 | -122.419856447043 | (37.7413645918137, -122.419856447043) | ||||
188711 | 188711 | 249682 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999744.1267099995 | 2117244.44172 | 37.7935335209065 | -122.444849738942 | (37.7935335209065, -122.444849738942) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");