trees
2,421 rows where qSpecies_id = 8 sorted by PlotSize descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
84405 | 177791 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 11:44:00 AM | 3 | Width 8ft | 6001956.24423 | 2086810.19432 | 37.710094340458 | -122.435017995105 | (37.710094340458, -122.435017995105) | 9 | 7 | 6 | 28861 | 5 | ||
141049 | 180766 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1206 Naples St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 09:29:00 AM | 3 | Width 8ft | 6001093.57723 | 2087421.33847 | 37.7117233858917 | -122.438043283865 | (37.7117233858917, -122.438043283865) | 9 | 7 | 6 | 28861 | 5 | ||
63646 | 223379 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2730 22nd St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 7ft | 6009758.65341 | 2103393.8455 | 37.7560694506528 | -122.4092206931 | (37.7560694506528, -122.4092206931) | 2 | 4 | 7 | 28859 | 19 | |||
24919 | 207665 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 5996615.28225 | 2106600.56008 | 37.7641291658503 | -122.454906302505 | (37.7641291658503, -122.454906302505) | 15 | 5 | 11 | 29492 | 12 | |||
25492 | 251734 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 898X Prague St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 08:08:00 AM | 3 | Width 6ft | 6002039.21061 | 2086908.72872 | 37.7103696049432 | -122.434738288839 | (37.7103696049432, -122.434738288839) | 9 | 7 | 6 | 28861 | 5 | ||
31379 | 251733 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 824 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:24:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.42241 | 37.7108048597154 | -122.433775443194 | (37.7108048597154, -122.433775443194) | 9 | 7 | 6 | 28861 | 5 | ||
42503 | 229348 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2970 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6009679.24982 | 2101052.76499 | 37.7496369166219 | -122.409330094713 | (37.7496369166219, -122.409330094713) | 2 | 4 | 7 | 28859 | 19 | |||
44380 | 180623 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 755 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:23:00 AM | 3 | Width 6ft | 6002495.21129 | 2087156.55582 | 37.7110759621502 | -122.433179952615 | (37.7110759621502, -122.433179952615) | 9 | 7 | 6 | 28861 | 5 | ||
47759 | 246581 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 184 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 6005207.86965 | 2109476.17522 | 37.772514077681 | -122.425391663601 | (37.772514077681, -122.425391663601) | 7 | 9 | 11 | 28852 | 10 | |||
48490 | 207572 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1640 09th Ave | 3 | Front Yard : Yard | Tree | Private 2 | 1 | Width 6ft | 5993421.18819 | 2104299.1531 | 37.7576263578793 | -122.465786433692 | (37.7576263578793, -122.465786433692) | 1 | 8 | 4 | 56 | 12 | |||
51071 | 246580 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 182 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 6005210.93182 | 2109452.28431 | 37.7724486520281 | -122.425379370776 | (37.7724486520281, -122.425379370776) | 7 | 9 | 11 | 28852 | 10 | |||
52633 | 207624 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1217 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 5995447.45032 | 2107265.73285 | 37.765888496982 | -122.458993633074 | (37.765888496982, -122.458993633074) | 15 | 5 | 11 | 56 | 12 | |||
64127 | 251732 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 824 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:20:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.42241 | 37.7108048597154 | -122.433775443194 | (37.7108048597154, -122.433775443194) | 9 | 7 | 6 | 28861 | 5 | ||
67765 | 223367 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3450 26th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006755.66784 | 2100887.58392 | 37.7490191327351 | -122.419428249231 | (37.7490191327351, -122.419428249231) | 2 | 4 | 7 | 28859 | 19 | |||
69377 | 180634 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 824 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:16:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.42241 | 37.7108048597154 | -122.433775443194 | (37.7108048597154, -122.433775443194) | 9 | 7 | 6 | 28861 | 5 | ||
76386 | 180625 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 18 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 6ft | 6002816.84046 | 2087215.85653 | 37.7112570289525 | -122.432072557104 | (37.7112570289525, -122.432072557104) | 9 | 7 | 6 | 28861 | 5 | |||
78086 | 207586 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1917 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993746.75792 | 2102455.06491 | 37.7525817412531 | -122.464526593251 | (37.7525817412531, -122.464526593251) | 1 | 8 | 4 | 29491 | 12 | |||
78457 | 176269 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 273 Curtis St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6000993.66237 | 2087160.73145 | 37.7110021341048 | -122.438369957219 | (37.7110021341048, -122.438369957219) | 9 | 7 | 6 | 28861 | 5 | |||
107073 | 180622 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 771 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:19:00 AM | 3 | Width 6ft | 6002476.28052 | 2087135.98969 | 37.7110184181363 | -122.433243913293 | (37.7110184181363, -122.433243913293) | 9 | 7 | 6 | 28861 | 5 | ||
109185 | 176268 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 273 Curtis St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6000987.65781 | 2087139.8501 | 37.7109444570035 | -122.43838921531 | (37.7109444570035, -122.43838921531) | 9 | 7 | 6 | 28861 | 5 | |||
116146 | 246582 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 198 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 6005203.89906 | 2109501.9724 | 37.7725846861634 | -122.425407234452 | (37.7725846861634, -122.425407234452) | 7 | 9 | 11 | 28852 | 10 | |||
124905 | 246577 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6005225.24464 | 2109364.93457 | 37.7722096193969 | -122.425323644264 | (37.7722096193969, -122.425323644264) | 7 | 9 | 11 | 28852 | 10 | |||
127368 | 176267 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 273 Curtis St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6000986.70381 | 2087103.40671 | 37.7108443372623 | -122.438389903289 | (37.7108443372623, -122.438389903289) | 9 | 7 | 6 | 28861 | 5 | |||
132321 | 223391 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 41 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6005260.46282 | 2105206.10338 | 37.7607924517343 | -122.424905885809 | (37.7607924517343, -122.424905885809) | 2 | 4 | 5 | 28859 | 19 | |||
146328 | 223407 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 819 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6010188.62668 | 2104419.00233 | 37.7589083810263 | -122.407805979477 | (37.7589083810263, -122.407805979477) | 10 | 4 | 7 | 28859 | 19 | |||
153436 | 223368 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3450 26th St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6006716.93708 | 2100883.67936 | 37.7490062301666 | -122.419561903754 | (37.7490062301666, -122.419561903754) | 2 | 4 | 7 | 28859 | 19 | |||
165102 | 207667 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 318 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 5993246.28637 | 2103941.58644 | 37.7566344820998 | -122.466365323703 | (37.7566344820998, -122.466365323703) | 1 | 8 | 4 | 56 | 12 | |||
168353 | 180626 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 18 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 6ft | 6002802.39914 | 2087193.02957 | 37.7111935323316 | -122.432120840807 | (37.7111935323316, -122.432120840807) | 9 | 7 | 6 | 28861 | 5 | |||
169516 | 207666 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 316 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 5993287.90775 | 2103943.61016 | 37.7566424402051 | -122.466221530195 | (37.7566424402051, -122.466221530195) | 1 | 8 | 4 | 56 | 12 | |||
178180 | 246578 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6005224.61763 | 2109380.51832 | 37.7722523731835 | -122.425326922304 | (37.7722523731835, -122.425326922304) | 7 | 9 | 11 | 28852 | 10 | |||
179288 | 180663 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 355 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 01:48:00 PM | 3 | Width 6ft | 6002383.84355 | 2086445.14687 | 37.7091162701556 | -122.433514058849 | (37.7091162701556, -122.433514058849) | 9 | 7 | 6 | 28861 | 5 | ||
191695 | 223392 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 35 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6005261.50146 | 2105224.90356 | 37.7608441312586 | -122.424903631195 | (37.7608441312586, -122.424903631195) | 2 | 4 | 5 | 28859 | 19 | |||
192280 | 207668 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 330 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 5993218.37994 | 2103939.27456 | 37.756626524017 | -122.466461665387 | (37.756626524017, -122.466461665387) | 1 | 8 | 4 | 56 | 12 | |||
7031 | 126517 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3835 Scott St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6000579.5194 | 2121468.07283 | 37.8051781307269 | -122.44226256568 | (37.8051781307269, -122.44226256568) | 13 | 9 | 1 | 57 | 17 | |||
9467 | 191059 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 215 05th St | 2 | : | Tree | Private 2 | 6 | Width 5ft | 6011805.95608 | 2111927.87879 | 37.7796164636776 | -122.402740539939 | (37.7796164636776, -122.402740539939) | 14 | 2 | 9 | 28856 | 34 | |||
9989 | 176265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Excelsior Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 5ft | 6004683.74002 | 2091261.8142 | 37.7224720200432 | -122.425907897826 | (37.7224720200432, -122.425907897826) | 9 | 7 | 6 | 28861 | 5 | |||
23708 | 223428 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 357 Precita Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6008915.2046 | 2100223.65051 | 37.7473175155876 | -122.411913617629 | (37.7473175155876, -122.411913617629) | 2 | 7 | 7 | 28859 | 2 | |||
23976 | 207635 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1450 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 5994307.66331 | 2105637.8573 | 37.7613531889164 | -122.462817781532 | (37.7613531889164, -122.462817781532) | 1 | 5 | 11 | 56 | 12 | |||
28415 | 223396 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 90 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6006003.81464 | 2104993.73555 | 37.7602512990686 | -122.42231986997 | (37.7602512990686, -122.42231986997) | 2 | 4 | 5 | 28859 | 19 | |||
39142 | 223599 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6007767.1377 | 2106084.40018 | 37.7633453203425 | -122.416298598605 | (37.7633453203425, -122.416298598605) | 8 | 4 | 7 | 28859 | 19 | |||
48194 | 172714 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1487 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 782598 | 6005831.81614 | 2119622.88276 | 37.8004096554382 | -122.42395503709 | (37.8004096554382, -122.42395503709) | 13 | 9 | 1 | 28858 | 32 | |
62521 | 223577 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6007069.07199 | 2097998.10728 | 37.7411029259504 | -122.418139669131 | (37.7411029259504, -122.418139669131) | 2 | 7 | 7 | 28859 | 2 | |||
65784 | 224099 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6003688.86609 | 2098162.22587 | 37.7413627203269 | -122.429838900151 | (37.7413627203269, -122.429838900151) | 2 | 7 | 5 | 63 | 7 | |||
66048 | 207657 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1343 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 5994851.17406 | 2106389.13082 | 37.7634472809955 | -122.460992472547 | (37.7634472809955, -122.460992472547) | 15 | 5 | 11 | 56 | 12 | |||
78250 | 176236 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 19 Brunswick St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6001058.00654 | 2087498.50838 | 37.711933254377 | -122.438171750223 | (37.711933254377, -122.438171750223) | 9 | 7 | 6 | 28861 | 5 | |||
84723 | 126495 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2700 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6000053.14506 | 2117822.05774 | 37.7951371326294 | -122.44382203238 | (37.7951371326294, -122.44382203238) | 13 | 9 | 1 | 57 | 17 | |||
86104 | 223371 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3527 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6006033.70926 | 2105484.59441 | 37.7616007686849 | -122.422251353329 | (37.7616007686849, -122.422251353329) | 2 | 4 | 5 | 28859 | 19 | |||
87007 | 246500 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 273 Duncan St | 1 | : | Tree | Private 2 | 10 | Width 5ft | 6004745.35521 | 2099854.76299 | 37.746069811469 | -122.426306403626 | (37.746069811469, -122.426306403626) | 2 | 7 | 5 | 63 | 22 | |||
91032 | 223537 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Noe St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 5ft | 6003218.0959 | 2100594.3408 | 37.7480140720016 | -122.431640256605 | (37.7480140720016, -122.431640256605) | 2 | 4 | 5 | 63 | 22 | |||
93522 | 256142 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1487 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 782598 | 6005892.76091 | 2119629.13744 | 37.8004302697025 | -122.423744588545 | (37.8004302697025, -122.423744588545) | 13 | 9 | 1 | 28858 | 32 | |
102958 | 176266 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Excelsior Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 5ft | 6004692.43448 | 2091256.7125 | 37.7224585032472 | -122.425877480072 | (37.7224585032472, -122.425877480072) | 9 | 7 | 6 | 28861 | 5 | |||
117894 | 223384 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 Cumberland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6005565.50658 | 2104580.7732 | 37.759092667419 | -122.423806408847 | (37.759092667419, -122.423806408847) | 2 | 4 | 5 | 28859 | 19 | |||
128807 | 223600 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6007768.16924 | 2106112.90661 | 37.76342365039 | -122.416297049994 | (37.76342365039, -122.416297049994) | 8 | 4 | 7 | 28859 | 19 | |||
134359 | 172715 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1487 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 782598 | 6005892.76091 | 2119629.13744 | 37.8004302697025 | -122.423744588545 | (37.8004302697025, -122.423744588545) | 13 | 9 | 1 | 28858 | 32 | |
139451 | 189250 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1301 Bay Shore Blvd | 4 | : | Tree | Private 2 | 11 | Width 5ft | 6011646.80648 | 2093004.20248 | 37.7276473117623 | -122.401960449138 | (37.7276473117623, -122.401960449138) | 10 | 3 | 8 | 58 | 1 | |||
144541 | 224098 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1414 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6002523.84844 | 2101397.51058 | 37.7501800108976 | -122.434098340276 | (37.7501800108976, -122.434098340276) | 2 | 4 | 5 | 28862 | 22 | |||
147685 | 223369 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3520 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6006269.04554 | 2100859.97677 | 37.7489159094411 | -122.421109035351 | (37.7489159094411, -122.421109035351) | 2 | 4 | 5 | 28859 | 19 | |||
148110 | 126540 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1926 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6008669.99624 | 2119504.05364 | 37.800243203509 | -122.414125355424 | (37.800243203509, -122.414125355424) | 3 | 1 | 10 | 308 | 32 | |||
150485 | 207658 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1347 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 5994853.56719 | 2106361.61895 | 37.7633718782394 | -122.460982201389 | (37.7633718782394, -122.460982201389) | 15 | 5 | 11 | 56 | 12 | |||
154941 | 223598 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 304 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6007773.13763 | 2106049.50965 | 37.7632498564254 | -122.41627537542 | (37.7632498564254, -122.41627537542) | 8 | 4 | 7 | 28859 | 19 | |||
156214 | 223383 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 Cumberland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6005540.24064 | 2104579.79946 | 37.7590885674118 | -122.423893721341 | (37.7590885674118, -122.423893721341) | 2 | 4 | 5 | 28859 | 19 | |||
160632 | 191058 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 215 05th St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011781.36835 | 2111952.66121 | 37.7796831376017 | -122.402827343412 | (37.7796831376017, -122.402827343412) | 14 | 2 | 9 | 28856 | 34 | |||
165373 | 207656 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1331 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 5994848.43771 | 2106461.01069 | 37.7636444870228 | -122.461007146788 | (37.7636444870228, -122.461007146788) | 15 | 5 | 11 | 56 | 12 | |||
168842 | 223445 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 318 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6003784.31175 | 2099553.81383 | 37.7451891045094 | -122.429608106246 | (37.7451891045094, -122.429608106246) | 2 | 7 | 5 | 63 | 22 | |||
172061 | 207703 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 161 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6000991.68804 | 2094917.78379 | 37.7323011315777 | -122.438932323977 | (37.7323011315777, -122.438932323977) | 9 | 7 | 4 | 63 | 40 | |||
176065 | 176235 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 19 Brunswick St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6001042.78255 | 2087493.58621 | 37.7119188733302 | -122.438224016125 | (37.7119188733302, -122.438224016125) | 9 | 7 | 6 | 28861 | 5 | |||
177048 | 223597 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 306 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6007773.49389 | 2106023.20364 | 37.7631776462561 | -122.416272279958 | (37.7631776462561, -122.416272279958) | 8 | 4 | 7 | 28859 | 19 | |||
182736 | 118075 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 426 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5985334.53877 | 2112983.7129 | 37.7810019204378 | -122.494393110571 | (37.7810019204378, -122.494393110571) | 11 | 6 | 2 | 55 | 26 | |||
806 | 189267 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Fairfax Ave | 6 | : | Tree | Private 2 | 1 | Width 4ft | 6017011.55747 | 2097196.03632 | 37.7394552087924 | -122.383705980546 | (37.7394552087924, -122.383705980546) | 10 | 3 | 8 | 58 | 1 | |||
1153 | 223389 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
1161 | 223387 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
2430 | 224109 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006481.46308 | 2109309.64111 | 37.7721286885111 | -122.420974342101 | (37.7721286885111, -122.420974342101) | 8 | 2 | 9 | 28853 | 19 | |||
3646 | 189251 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Loomis St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6010844.92077 | 2097998.29295 | 37.7413152397136 | -122.405084094075 | (37.7413152397136, -122.405084094075) | 10 | 3 | 8 | 58 | 1 | |||
10369 | 223584 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007576 | 2096576 | 37.7372266531625 | -122.41628619091 | (37.7372266531625, -122.41628619091) | 2 | 7 | 7 | 28859 | 2 | |||
12028 | 261519 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 658 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:20:00 PM | Width 4ft | 5982910.9702 | 2111318.38005 | 37.7762872714849 | -122.502653994406 | (37.7762872714849, -122.502653994406) | 11 | 6 | 2 | 55 | 26 | |||
12094 | 223388 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
14335 | 126528 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2865 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999858.5831 | 2117397.02889 | 37.7939590162525 | -122.444464683403 | (37.7939590162525, -122.444464683403) | 13 | 9 | 1 | 57 | 27 | |||
14607 | 144226 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 786 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:53:00 PM | 0 | Width 4ft | 5982632.5127 | 2110441.98121 | 37.7738645680338 | -122.503552325389 | (37.7738645680338, -122.503552325389) | 11 | 6 | 2 | 55 | 26 | ||
14856 | 126525 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3321 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6004100.5255 | 2120576.79123 | 37.8029309470697 | -122.430014078187 | (37.8029309470697, -122.430014078187) | 13 | 9 | 1 | 57 | 17 | |||
15567 | 223585 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6007519 | 2096543 | 37.7371328370553 | -122.416480929712 | (37.7371328370553, -122.416480929712) | 2 | 7 | 7 | 28859 | 2 | |||
15652 | 147295 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 859 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5987874.57425 | 2110110.67904 | 37.7732616993961 | -122.485395090629 | (37.7732616993961, -122.485395090629) | 11 | 6 | 2 | 55 | 26 | |||
16530 | 223386 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3665 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005227.03743 | 2104855.48781 | 37.7598278559952 | -122.424996542879 | (37.7598278559952, -122.424996542879) | 2 | 4 | 5 | 28859 | 19 | |||
17745 | 207576 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1245 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5993280.81145 | 2107003.85945 | 37.7650446756837 | -122.466468488529 | (37.7650446756837, -122.466468488529) | 11 | 8 | 11 | 56 | 12 | |||
19933 | 223498 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 255 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006745.96401 | 2102320.90162 | 37.7529541496195 | -122.41956348298 | (37.7529541496195, -122.41956348298) | 2 | 4 | 7 | 28859 | 19 | |||
20602 | 126531 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1870 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005210.197 | 2117169.09516 | 37.7936370652524 | -122.425931322478 | (37.7936370652524, -122.425931322478) | 13 | 9 | 1 | 28858 | 27 | |||
24453 | 120820 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 20th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5989571.70093 | 2114608.17958 | 37.7857093094708 | -122.47985374027 | (37.7857093094708, -122.47985374027) | 11 | 6 | 2 | 55 | 26 | |||
28703 | 223452 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998137.72031 | 2105984.6438 | 37.7625252312687 | -122.449596269873 | (37.7625252312687, -122.449596269873) | 15 | 5 | 11 | 29492 | 9 | |||
29432 | 223456 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 508 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5998596.25965 | 2106249.17699 | 37.7632777947483 | -122.448029403535 | (37.7632777947483, -122.448029403535) | 15 | 5 | 11 | 29492 | 9 | |||
29823 | 207664 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 428 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5996430.67292 | 2106975.20707 | 37.7651472586653 | -122.455571889857 | (37.7651472586653, -122.455571889857) | 15 | 5 | 11 | 29492 | 12 | |||
30507 | 207570 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1425 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5993940.55788 | 2105777.49426 | 37.7617154448214 | -122.464097572554 | (37.7617154448214, -122.464097572554) | 1 | 5 | 11 | 56 | 12 | |||
31692 | 189252 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Loomis St | 2 | : | Tree | Private 2 | 1 | Width 4ft | 6010838.98568 | 2097984.08803 | 37.7412759042668 | -122.40510361565 | (37.7412759042668, -122.40510361565) | 10 | 3 | 8 | 58 | 1 | |||
33358 | 189266 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 550 Bay Shore Blvd | 2 | : | Tree | Private 2 | 9 | Width 4ft | 6010210.57589 | 2097161.88665 | 37.7389831663466 | -122.407218500042 | (37.7389831663466, -122.407218500042) | 10 | 3 | 7 | 58 | 2 | |||
36123 | 126557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011999.63961 | 2119254.38216 | 37.7997441211609 | -122.402585850275 | (37.7997441211609, -122.402585850275) | 3 | 1 | 10 | 308 | 23 | |||
36383 | 223525 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4126 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6002321.16912 | 2101815.04035 | 37.7513149436309 | -122.434829071802 | (37.7513149436309, -122.434829071802) | 2 | 4 | 5 | 28862 | 22 | |||
37052 | 223427 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 357 Precita Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008897.95249 | 2100223.67255 | 37.747316608191 | -122.411973275956 | (37.747316608191, -122.411973275956) | 2 | 7 | 7 | 28859 | 2 | |||
38208 | 207601 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 129 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5995608.85604 | 2090759.60342 | 37.720576034226 | -122.457241192545 | (37.720576034226, -122.457241192545) | 9 | 8 | 6 | 28861 | 24 | |||
40084 | 223469 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 945 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998759.82917 | 2106683.9118 | 37.7644808160601 | -122.447494967025 | (37.7644808160601, -122.447494967025) | 15 | 5 | 11 | 29492 | 9 | |||
41731 | 126559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012005.05894 | 2119209.80303 | 37.7996220201986 | -122.402563960758 | (37.7996220201986, -122.402563960758) | 3 | 1 | 10 | 308 | 23 | |||
46659 | 223403 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3624 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005621.17135 | 2101994.19422 | 37.7519936655859 | -122.423430010205 | (37.7519936655859, -122.423430010205) | 2 | 4 | 5 | 28859 | 19 | |||
50221 | 191111 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2251 24th St | 4 | : | Tree | Private 2 | 11 | Width 4ft | 6011810.68033 | 2102303.0748 | 37.7531891829555 | -122.402047375812 | (37.7531891829555, -122.402047375812) | 10 | 3 | 8 | 28856 | 29 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );