trees
2,421 rows where qSpecies_id = 8 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
814 | 261435 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 371 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007244 | 2095778 | 37.7350168462428 | -122.417377534221 | (37.7350168462428, -122.417377534221) | 2 | 7 | 7 | 28859 | 2 | ||||
908 | 207538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993510.99578 | 2106611.92865 | 37.7639818164203 | -122.465643867796 | (37.7639818164203, -122.465643867796) | 1 | 8 | 11 | 56 | 12 | |||
1085 | 223588 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x Jarboe Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6009063.07444 | 2096876.26549 | 37.7381346254237 | -122.411165877211 | (37.7381346254237, -122.411165877211) | 10 | 7 | 7 | 28859 | 2 | |||
1123 | 72265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 358 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002353.80444 | 2091524.36294 | 37.7230609707806 | -122.433980702666 | (37.7230609707806, -122.433980702666) | 9 | 7 | 6 | 28861 | 5 | |||
1140 | 223581 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 85 Bessie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008353.87265 | 2100058.32291 | 37.7468320543491 | -122.413842976384 | (37.7468320543491, -122.413842976384) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
1327 | 261443 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 354 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007142 | 2095710 | 37.7348243937619 | -122.417725367022 | (37.7348243937619, -122.417725367022) | 2 | 7 | 7 | 28859 | 2 | ||||
1419 | 148015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 703 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002502.98722 | 2088786.72578 | 37.7155524923237 | -122.433269485517 | (37.7155524923237, -122.433269485517) | 9 | 7 | 6 | 28861 | 5 | |||
1423 | 223556 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 701x Andover St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007456 | 2095683 | 37.7347679226533 | -122.416637845271 | (37.7347679226533, -122.416637845271) | 2 | 7 | 7 | 28859 | 2 | |||
1507 | 74233 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2400 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6010292.05063 | 2106000.69739 | 37.7632571481177 | -122.407559806245 | (37.7632571481177, -122.407559806245) | 8 | 4 | 8 | 28859 | 19 | |||
1530 | 191101 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2041 26th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012369.93883 | 2101402.46492 | 37.7507475020033 | -122.400050093052 | (37.7507475020033, -122.400050093052) | 10 | 3 | 8 | 28856 | 1 | |||
1541 | 70231 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6005265.5585 | 2110935.6138 | 37.7765246008409 | -122.425295984643 | (37.7765246008409, -122.425295984643) | 7 | 9 | 11 | 28852 | 10 | |||
1628 | 72055 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2161 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6008082.6141 | 2119894.27994 | 37.8012816578905 | -122.416185586193 | (37.8012816578905, -122.416185586193) | 5 | 1 | 1 | 308 | 32 | |||
1793 | 260413 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1510 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015825 | 2096697 | 37.7380192974637 | -122.387773802776 | (37.7380192974637, -122.387773802776) | 10 | 3 | 8 | 58 | 1 | ||||
2148 | 154032 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1662 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014879.40227 | 2097032.81009 | 37.7388889362706 | -122.391066694069 | (37.7388889362706, -122.391066694069) | 10 | 3 | 8 | 58 | 1 | |||
2303 | 223507 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006548.17508 | 2102589.95451 | 37.7536817641104 | -122.420266570244 | (37.7536817641104, -122.420266570244) | 2 | 4 | 7 | 28859 | 19 | |||
2337 | 223401 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3647 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6005476.77928 | 2102530.01598 | 37.7534567573481 | -122.423967438743 | (37.7534567573481, -122.423967438743) | 2 | 4 | 5 | 28859 | 19 | |||
2408 | 162789 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 237 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 5996026.23717 | 2090535.13208 | 37.71998365171 | -122.455782228671 | (37.71998365171, -122.455782228671) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
2450 | 251744 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 70 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002620 | 2086992 | 37.710631205907 | -122.432736905509 | (37.710631205907, -122.432736905509) | 9 | 7 | 6 | 28861 | 5 | ||||
2532 | 72297 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 463 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6002248.50751 | 2090769.44278 | 37.7209821527804 | -122.434290747523 | (37.7209821527804, -122.434290747523) | 9 | 7 | 6 | 28861 | 5 | |||
3110 | 126516 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3449 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5997745.83933 | 2116374.85745 | 37.7910316321555 | -122.451701179872 | (37.7910316321555, -122.451701179872) | 11 | 6 | 1 | 54 | 31 | |||
3265 | 255205 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
3320 | 245104 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Central Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999855.4831 | 2109410.1992 | 37.7720290692692 | -122.443901304248 | (37.7720290692692, -122.443901304248) | 15 | 5 | 11 | 29492 | 9 | |||
3440 | 223611 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 255 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006745.90219 | 2102323.75764 | 37.752961988114 | -122.419563899379 | (37.752961988114, -122.419563899379) | 2 | 4 | 7 | 28859 | 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 | |||
3755 | 200657 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1520 Oakdale Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015286.398 | 2095330.3246 | 37.7342368342044 | -122.389540612503 | (37.7342368342044, -122.389540612503) | 10 | 3 | 8 | 58 | 1 | |||
3889 | 223641 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006696.02527 | 2102542.97279 | 37.753561093073 | -122.419751936808 | (37.753561093073, -122.419751936808) | 2 | 4 | 7 | 28859 | 19 | |||
3936 | 172254 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1007 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6004516.89039 | 2090643.22078 | 37.7207640671979 | -122.426440635537 | (37.7207640671979, -122.426440635537) | 9 | 7 | 6 | 28861 | 5 | |||
3971 | 172343 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 164 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6001347.87441 | 2087361.61872 | 37.7115738673031 | -122.437160092082 | (37.7115738673031, -122.437160092082) | 9 | 7 | 6 | 28861 | 5 | |||
3984 | 243570 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 3 | 3x3 | Permit Number 784594 | 6001117.2647 | 2099653.19311 | 37.7453106011164 | -122.438837397829 | (37.7453106011164, -122.438837397829) | 2 | 4 | 5 | 63 | 22 | |
4081 | 145032 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 154 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 5x5 | 5991192.39146 | 2114393.22168 | 37.7852131174265 | -122.47423097869 | (37.7852131174265, -122.47423097869) | 11 | 6 | 2 | 54 | 26 | |||
4187 | 78365 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 671 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002103.17705 | 2090031.785 | 37.7189484591704 | -122.434740388752 | (37.7189484591704, -122.434740388752) | 9 | 7 | 6 | 28861 | 5 | |||
4341 | 255207 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
4522 | 141909 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004576.1236 | 2111931.0419 | 37.7792188274982 | -122.427751880486 | (37.7792188274982, -122.427751880486) | 7 | 9 | 11 | 29490 | 41 | |||
4551 | 189261 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2215 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011901.66973 | 2098145.68488 | 37.7417789652237 | -122.401440561855 | (37.7417789652237, -122.401440561855) | 10 | 3 | 8 | 58 | 1 | |||
4693 | 255208 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
5283 | 71380 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1415 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6015545.815 | 2094978.0232 | 37.7332838660921 | -122.388619133184 | (37.7332838660921, -122.388619133184) | 10 | 3 | 8 | 58 | 1 | |||
5449 | 245103 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999859.4717 | 2109392.5831 | 37.7719809274281 | -122.443886241527 | (37.7719809274281, -122.443886241527) | 15 | 5 | 11 | 29492 | 9 | |||
5781 | 207615 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Ralston St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992209.13787 | 2088815.67824 | 37.7150426450832 | -122.46885145275 | (37.7150426450832, -122.46885145275) | 9 | 8 | 6 | 64 | 24 | |||
6046 | 81390 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1588 Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6015103.68734 | 2101191.55999 | 37.750320442739 | -122.390581737352 | (37.750320442739, -122.390581737352) | 10 | 3 | 8 | 28856 | 1 | |||
6250 | 261442 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 364 Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2095707 | 37.7348180134015 | -122.417611061749 | (37.7348180134015, -122.417611061749) | 2 | 7 | 7 | 28859 | 2 | ||||
6331 | 261440 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 374x Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007239 | 2095686 | 37.7347639531109 | -122.417388303298 | (37.7347639531109, -122.417388303298) | 2 | 7 | 7 | 28859 | 2 | ||||
6449 | 71444 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1088 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012034.251 | 2119394.2595 | 37.8001301227773 | -122.402475922527 | (37.8001301227773, -122.402475922527) | 3 | 1 | 10 | 28860 | 6 | |||
6487 | 261445 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 339 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007092 | 2095790 | 37.7350412423636 | -122.417903903871 | (37.7350412423636, -122.417903903871) | 2 | 7 | 7 | 28859 | 2 | ||||
6857 | 83788 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 482 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5994387.70821 | 2112243.63782 | 37.779495530287 | -122.463020234423 | (37.779495530287, -122.463020234423) | 11 | 6 | 2 | 54 | 11 | |||
7024 | 141437 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005239.6877 | 2110933.7323 | 37.7765179730819 | -122.425385345316 | (37.7765179730819, -122.425385345316) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
7067 | 223489 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 201x Tompkins Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6007880.65482 | 2096572.00473 | 37.73723280954 | -122.415232573728 | (37.73723280954, -122.415232573728) | 2 | 7 | 7 | 28859 | 2 | |||
7451 | 255209 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
7521 | 82066 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 178 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6x9 | 5993381.48495 | 2114348.32206 | 37.7852164089009 | -122.466654188344 | (37.7852164089009, -122.466654188344) | 11 | 6 | 2 | 54 | 11 | ||
7729 | 223606 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 552 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007244.98796 | 2104086.07115 | 37.7578289967226 | -122.417962880381 | (37.7578289967226, -122.417962880381) | 2 | 4 | 7 | 28859 | 19 | |||
7760 | 261189 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 599x Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007159 | 2095436 | 37.7340730065148 | -122.41764717788 | (37.7340730065148, -122.41764717788) | 2 | 7 | 7 | 28859 | 2 | ||||
8093 | 223555 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 701x Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007456 | 2095683 | 37.7347679226533 | -122.416637845271 | (37.7347679226533, -122.416637845271) | 2 | 7 | 7 | 28859 | 2 | |||
8256 | 144400 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 622 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 5987240.24391 | 2111690.94043 | 37.7775636765575 | -122.487705414786 | (37.7775636765575, -122.487705414786) | 11 | 6 | 2 | 55 | 26 | |||
8480 | 72470 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 955 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012030.25538 | 2119045.53422 | 37.7991723843595 | -122.402465214308 | (37.7991723843595, -122.402465214308) | 3 | 1 | 10 | 308 | 23 | |||
8533 | 71618 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 950 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012375.88529 | 2119419.34267 | 37.8002180611838 | -122.401295492211 | (37.8002180611838, -122.401295492211) | 3 | 1 | 10 | 28860 | 6 | |||
8681 | 223586 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007519 | 2096543 | 37.7371328370553 | -122.416480929712 | (37.7371328370553, -122.416480929712) | 2 | 7 | 7 | 28859 | 2 | |||
8809 | 223493 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007980.72085 | 2102939.00638 | 37.7547207985381 | -122.415337199951 | (37.7547207985381, -122.415337199951) | 2 | 4 | 7 | 28859 | 19 | |||
8863 | 224037 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4136 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002973.28417 | 2101264.18156 | 37.7498394178669 | -122.432534643177 | (37.7498394178669, -122.432534643177) | 2 | 4 | 5 | 28862 | 22 | |||
9156 | 73920 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6008409.30532 | 2108731.32076 | 37.7706492380987 | -122.414264830382 | (37.7706492380987, -122.414264830382) | 8 | 2 | 9 | 28853 | 19 | |||
9157 | 261444 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 350 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007112 | 2095712 | 37.7348281970622 | -122.417829229388 | (37.7348281970622, -122.417829229388) | 2 | 7 | 7 | 28859 | 2 | ||||
9259 | 112872 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 599x CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5999621 | 2110473 | 37.7749338721416 | -122.444788804756 | (37.7749338721416, -122.444788804756) | 15 | 5 | 11 | 29492 | 16 | |||
9295 | 223587 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x Jarboe Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6009072.26343 | 2096875.24392 | 37.7381323357409 | -122.411134034011 | (37.7381323357409, -122.411134034011) | 10 | 7 | 7 | 28859 | 2 | |||
9337 | 244882 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1397 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999938.3807 | 2109154.2405 | 37.7713309995727 | -122.443596165541 | (37.7713309995727, -122.443596165541) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
9542 | 261434 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 383 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007317 | 2095771 | 37.7350017327518 | -122.417124650781 | (37.7350017327518, -122.417124650781) | 2 | 7 | 7 | 28859 | 2 | ||||
9657 | 126497 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1651 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005046.68269 | 2119164.91299 | 37.7991078310233 | -122.426639284086 | (37.7991078310233, -122.426639284086) | 13 | 9 | 1 | 57 | 17 | |||
9764 | 150815 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 640 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013813.37874 | 2104087.70708 | 37.7582009725247 | -122.395246594574 | (37.7582009725247, -122.395246594574) | 10 | 3 | 8 | 28856 | 29 | |||
9952 | 148016 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 703 Italy Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002451.59987 | 2088819.6954 | 37.7156401042879 | -122.433449457832 | (37.7156401042879, -122.433449457832) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
10016 | 261433 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 393 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007343 | 2095769 | 37.7349977038172 | -122.417034617662 | (37.7349977038172, -122.417034617662) | 2 | 7 | 7 | 28859 | 2 | ||||
10065 | 223575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007323 | 2098000 | 37.7411224122402 | -122.417261809722 | (37.7411224122402, -122.417261809722) | 2 | 7 | 7 | 28859 | 2 | |||
10072 | 223589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 590X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008529.06402 | 2096927.29731 | 37.7382447851783 | -122.413015832133 | (37.7382447851783, -122.413015832133) | 10 | 7 | 7 | 28859 | 2 | |||
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 | |||
10433 | 189238 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2126 24th St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6012108.67622 | 2102369.63804 | 37.75338857883 | -122.401021516451 | (37.75338857883, -122.401021516451) | 10 | 3 | 8 | 28856 | 29 | |||
10631 | 106353 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 3520X 26TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6006283 | 2100840 | 37.7488618444312 | -122.421059362487 | (37.7488618444312, -122.421059362487) | 2 | 4 | 5 | 28859 | 19 | |||
10646 | 172228 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 203 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6002933 | 2092317 | 37.7252702278754 | -122.432035115452 | (37.7252702278754, -122.432035115452) | 9 | 7 | 6 | 28861 | 5 | |||
10927 | 74852 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1660 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009221.87688 | 2119018.0672 | 37.7989397873109 | -122.412181258567 | (37.7989397873109, -122.412181258567) | 3 | 1 | 10 | 308 | 4 | |||
11087 | 122015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1799 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990132.5051 | 2110630.33529 | 37.7748198185001 | -122.477622678128 | (37.7748198185001, -122.477622678128) | 11 | 6 | 2 | 55 | 26 | |||
11167 | 78311 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 651 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002171.16475 | 2090137.23408 | 37.7192418585039 | -122.434512917837 | (37.7192418585039, -122.434512917837) | 9 | 7 | 6 | 28861 | 5 | |||
11395 | 69965 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1039 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5992352.53877 | 2110655.12549 | 37.7750164659141 | -122.469944995693 | (37.7750164659141, -122.469944995693) | 11 | 6 | 2 | 54 | 11 | |||
11488 | 71394 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1549 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6015490.02353 | 2096504.22569 | 37.7374714167655 | -122.388918537456 | (37.7374714167655, -122.388918537456) | 10 | 3 | 8 | 58 | 1 | |||
11545 | 261446 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 329 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007068 | 2095792 | 37.7350453831972 | -122.417987022359 | (37.7350453831972, -122.417987022359) | 2 | 7 | 7 | 28859 | 2 | ||||
11592 | 224089 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 224 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004580.79593 | 2109148.95091 | 37.7715801506238 | -122.427537458604 | (37.7715801506238, -122.427537458604) | 7 | 9 | 11 | 28852 | 10 | |||
11818 | 207596 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 506 Faxon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5994790.18426 | 2091971.80036 | 37.7238573834024 | -122.460158838768 | (37.7238573834024, -122.460158838768) | 9 | 8 | 4 | 28861 | 24 | |||
11823 | 223370 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99 Lapidge St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6006029.2284 | 2104988.85011 | 37.7602393183104 | -122.422231628499 | (37.7602393183104, -122.422231628499) | 2 | 4 | 5 | 28859 | 19 | |||
11873 | 224059 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3628 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002696.79261 | 2106527.84926 | 37.7642765053752 | -122.433866946505 | (37.7642765053752, -122.433866946505) | 15 | 5 | 5 | 28862 | 3 | |||
11903 | 73567 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1549 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6015475.76559 | 2096515.71199 | 37.7375021654981 | -122.388968635992 | (37.7375021654981, -122.388968635992) | 10 | 3 | 8 | 58 | 1 | |||
12056 | 207640 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 Funston Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992163.90266 | 2104824.95669 | 37.7589974714712 | -122.47017288688 | (37.7589974714712, -122.47017288688) | 1 | 8 | 4 | 56 | 12 | |||
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 | |||
12961 | 70529 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1930 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | Permit Number 782472 | 5999916.9745 | 2111278.4432 | 37.7771623000193 | -122.443822848555 | (37.7771623000193, -122.443822848555) | 15 | 5 | 11 | 29490 | 16 | ||
13100 | 176239 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009040.83689 | 2090406.80665 | 37.7203696227506 | -122.410785993677 | (37.7203696227506, -122.410785993677) | 9 | 3 | 7 | 309 | 28 | |||
13230 | 260498 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 349 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6000178 | 2110153 | 37.7740870040886 | -122.442839045318 | (37.7740870040886, -122.442839045318) | 15 | 5 | 11 | 29492 | 16 | ||||
13393 | 207553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993922.26035 | 2106313.56882 | 37.7631863112193 | -122.464199775125 | (37.7631863112193, -122.464199775125) | 1 | 5 | 11 | 56 | 12 | |||
13425 | 223490 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008605.30011 | 2107940.39716 | 37.768488553924 | -122.41353093232 | (37.768488553924, -122.41353093232) | 8 | 4 | 7 | 28853 | 19 | |||
13899 | 223627 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 324 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006726 | 2101710 | 37.7512756289395 | -122.419589182986 | (37.7512756289395, -122.419589182986) | 2 | 4 | 7 | 28859 | 19 | |||
14213 | 74019 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2400 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 6010272.25282 | 2105997.87843 | 37.7632482996846 | -122.407628081878 | (37.7632482996846, -122.407628081878) | 8 | 4 | 8 | 28859 | 19 |
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) );