trees
348 rows where Police Districts = 4 and qSpecies_id = 8 sorted by DBH
This data as json, CSV (advanced)
These facets timed out: Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3218 | 84023 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 309 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 773233 | 6004808.26935881 | 2101900.57071737 | 37.7516906826671 | -122.42623448013 | (37.7516906826671, -122.42623448013) | 2 | 4 | 5 | 28862 | 22 | ||
5257 | 62102 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 440 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1985 12:00:00 AM | Permit Number 22195 | 6006762.92692973 | 2101210.352632 | 37.7499057910946 | -122.419426042368 | (37.7499057910946, -122.419426042368) | 2 | 4 | 7 | 28859 | 19 | ||
8997 | 47687 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2002 12:00:00 AM | Permit Number 45486 | 6003826.76338909 | 2102198.68251842 | 37.7524537008518 | -122.429649915481 | (37.7524537008518, -122.429649915481) | 2 | 4 | 5 | 28862 | 22 | |||
14895 | 42944 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42839 | 6007671.6020798 | 2107773.96917263 | 37.7679791099284 | -122.416748729284 | (37.7679791099284, -122.416748729284) | 8 | 4 | 7 | 28853 | 19 | ||
18040 | 33037 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 494 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37315 | 6006779.65662971 | 2100908.40918731 | 37.7490776652966 | -122.41934677281 | (37.7490776652966, -122.41934677281) | 2 | 4 | 7 | 28859 | 19 | |||
28255 | 39127 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 739 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40808 | 6007354.16846215 | 2103008.55652832 | 37.7548765329449 | -122.417508922955 | (37.7548765329449, -122.417508922955) | 2 | 4 | 7 | 28859 | 19 | ||
29275 | 257895 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3644 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | ||||
30499 | 83186 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3453 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50577 | 6006512.76900503 | 2105506.90807829 | 37.7616890471737 | -122.420596061932 | (37.7616890471737, -122.420596061932) | 2 | 4 | 7 | 28859 | 19 | ||
32577 | 35506 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3451 22nd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38909 | 6005392.68349986 | 2103106.02983212 | 37.75503360932 | -122.424299225131 | (37.75503360932, -122.424299225131) | 2 | 4 | 5 | 28859 | 19 | ||
34948 | 63791 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4079 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24477 | 6003353.40286408 | 2101237.77442121 | 37.7497884585709 | -122.43121829162 | (37.7497884585709, -122.43121829162) | 2 | 4 | 5 | 28862 | 22 | ||
36552 | 37407 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1710 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39887 | 6002579.2352778 | 2100599.04049757 | 37.7479907436881 | -122.433849744568 | (37.7479907436881, -122.433849744568) | 2 | 4 | 5 | 63 | 22 | |||
37767 | 35299 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4128 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/1998 12:00:00 AM | Permit Number 38772 | 6002342.17007059 | 2101820.0635556 | 37.7513299284774 | -122.434756807393 | (37.7513299284774, -122.434756807393) | 2 | 4 | 5 | 28862 | 22 | |||
39751 | 96590 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
44908 | 96593 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
46394 | 66647 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 972 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/2000 12:00:00 AM | Permit Number 29858 | 6010191.86940681 | 2103559.76448884 | 37.756549288119 | -122.407734178809 | (37.756549288119, -122.407734178809) | 2 | 4 | 7 | 28859 | 19 | ||
47805 | 46326 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3649 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/2002 12:00:00 AM | Permit Number 44579 | 6005434.40207527 | 2102522.16800234 | 37.7534328160504 | -122.424113430233 | (37.7534328160504, -122.424113430233) | 2 | 4 | 5 | 28859 | 19 | ||
48287 | 50062 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 259 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46792 | 6004623.22870051 | 2103939.22214247 | 37.7572778811094 | -122.427019561527 | (37.7572778811094, -122.427019561527) | 2 | 4 | 5 | 28862 | 3 | ||
53539 | 35777 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3528 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1998 12:00:00 AM | Permit Number 39032 | 6006085.57014843 | 2104950.10312581 | 37.7601361059974 | -122.422034016017 | (37.7601361059974, -122.422034016017) | 2 | 4 | 5 | 28859 | 19 | ||
55160 | 108690 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 61 OAKWOOD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005327.5 | 2105108.8 | 37.7605290659119 | -122.424667111807 | (37.7605290659119, -122.424667111807) | 2 | 4 | 5 | 28859 | 19 | ||||
55473 | 39119 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 552 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40804 | 6007242.03781645 | 2104093.13141214 | 37.7578482165395 | -122.417973583722 | (37.7578482165395, -122.417973583722) | 2 | 4 | 7 | 28859 | 19 | ||
56214 | 38319 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | Permit Number 774280 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.413465790173 | (37.7684292621485, -122.413465790173) | 8 | 4 | 7 | 28853 | 19 | |||
63210 | 96591 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
68249 | 56109 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3330 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1985 12:00:00 AM | Permit Number 22207 | 6006832.6652986 | 2102651.38828329 | 37.7538664735729 | -122.419287095 | (37.7538664735729, -122.419287095) | 2 | 4 | 7 | 28859 | 19 | ||
68951 | 33009 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3616 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37303 | 6005672.83784214 | 2102003.77697796 | 37.752022893602 | -122.423252020871 | (37.752022893602, -122.423252020871) | 2 | 4 | 5 | 28859 | 19 | ||
70969 | 47557 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 206 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45420 | 6004100.72419306 | 2102141.4355601 | 37.7523120229359 | -122.428698432782 | (37.7523120229359, -122.428698432782) | 2 | 4 | 5 | 28862 | 22 | |||
71264 | 47688 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2002 12:00:00 AM | Permit Number 45486 | 6003826.76338909 | 2102198.68251842 | 37.7524537008518 | -122.429649915481 | (37.7524537008518, -122.429649915481) | 2 | 4 | 5 | 28862 | 22 | |||
73700 | 46325 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3649 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2002 12:00:00 AM | Permit Number 56854 | 6005434.40207527 | 2102522.16800234 | 37.7534328160504 | -122.424113430233 | (37.7534328160504, -122.424113430233) | 2 | 4 | 5 | 28859 | 19 | |||
75277 | 32838 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1414 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37193 | 6002529.48991502 | 2101462.27171946 | 37.7503581498404 | -122.434083460627 | (37.7503581498404, -122.434083460627) | 2 | 4 | 5 | 28862 | 22 | ||
78114 | 33048 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1192 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37324 | 6005740.26598795 | 2102030.16267757 | 37.7520991477767 | -122.423020719371 | (37.7520991477767, -122.423020719371) | 2 | 4 | 5 | 28859 | 19 | ||
78696 | 42947 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 370 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42842 | 6007791.87448942 | 2105665.73605783 | 37.7621971566206 | -122.416183388947 | (37.7621971566206, -122.416183388947) | 8 | 4 | 7 | 28859 | 19 | ||
80336 | 62118 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 473 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1985 12:00:00 AM | Permit Number 22220 | 6006824.76119309 | 2101034.29989716 | 37.749425872837 | -122.419199729312 | (37.749425872837, -122.419199729312) | 2 | 4 | 7 | 28859 | 19 | ||
81530 | 96594 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
82057 | 42946 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 64 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42841 | 6007766.22670563 | 2106145.49280526 | 37.7635130152875 | -122.416306076762 | (37.7635130152875, -122.416306076762) | 8 | 4 | 7 | 28859 | 19 | ||
82251 | 37664 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3250 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2004 12:00:00 AM | Permit Number 40070 | 6007810.11967641 | 2105631.1413248 | 37.7621031933661 | -122.416117835461 | (37.7621031933661, -122.416117835461) | 8 | 4 | 7 | 28859 | 19 | ||
84014 | 60994 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4126 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25142 | 6003063.49787732 | 2100688.38010697 | 37.7482635177611 | -122.432181564789 | (37.7482635177611, -122.432181564789) | 2 | 4 | 5 | 28862 | 22 | ||
85610 | 64683 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 306 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/1988 12:00:00 AM | Permit Number 25622 | 6007786.51024737 | 2105766.07733259 | 37.7624723689104 | -122.416209048783 | (37.7624723689104, -122.416209048783) | 8 | 4 | 7 | 28859 | 19 | ||
86401 | 32839 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1414 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37193 | 6002529.48991502 | 2101462.27171946 | 37.7503581498404 | -122.434083460627 | (37.7503581498404, -122.434083460627) | 2 | 4 | 5 | 28862 | 22 | ||
92554 | 47689 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2002 12:00:00 AM | Permit Number 45486 | 6003826.76338909 | 2102198.68251842 | 37.7524537008518 | -122.429649915481 | (37.7524537008518, -122.429649915481) | 2 | 4 | 5 | 28862 | 22 | |||
96957 | 59269 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3438 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | Permit Number 29732 | 6005419.26991324 | 2103743.28355655 | 37.7567848606038 | -122.424252601663 | (37.7567848606038, -122.424252601663) | 2 | 4 | 5 | 28859 | 19 | ||
97614 | 64685 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 304 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/1988 12:00:00 AM | Permit Number 25625 | 6007786.34261543 | 2105769.21298565 | 37.7624809692619 | -122.416209850653 | (37.7624809692619, -122.416209850653) | 8 | 4 | 7 | 28859 | 19 | ||
99318 | 47684 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3250 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2002 12:00:00 AM | Permit Number 45476 | 6007810.11967641 | 2105631.1413248 | 37.7621031933661 | -122.416117835461 | (37.7621031933661, -122.416117835461) | 8 | 4 | 7 | 28859 | 19 | |||
99906 | 61867 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1318 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/1999 12:00:00 AM | Permit Number 21907 | 6010305.63286425 | 2101528.54455683 | 37.7509783771367 | -122.407197563662 | (37.7509783771367, -122.407197563662) | 2 | 4 | 7 | 28859 | 19 | ||
100404 | 48936 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2753 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46124 | 6008970.19382594 | 2102433.57534311 | 37.7533885608678 | -122.411879606442 | (37.7533885608678, -122.411879606442) | 2 | 4 | 7 | 28859 | 19 | ||
101299 | 84156 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 618-620 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2012 12:00:00 AM | 3x3 | Permit Number 769487 | 6007864.16010864 | 2104318.1275589 | 37.7585009983288 | -122.415837950653 | (37.7585009983288, -122.415837950653) | 2 | 4 | 7 | 28859 | 19 | ||
101360 | 46327 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3649 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/2002 12:00:00 AM | Permit Number 44579 | 6005434.40207527 | 2102522.16800234 | 37.7534328160504 | -122.424113430233 | (37.7534328160504, -122.424113430233) | 2 | 4 | 5 | 28859 | 19 | ||
102187 | 39314 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3248 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40892 | 6007145.08024569 | 2106178.91659474 | 37.7635698413851 | -122.418456799551 | (37.7635698413851, -122.418456799551) | 8 | 4 | 7 | 28859 | 19 | ||
107647 | 37400 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4235 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39882 | 6002342.85662573 | 2101181.62217602 | 37.7495769587767 | -122.434708784267 | (37.7495769587767, -122.434708784267) | 2 | 4 | 5 | 28862 | 22 | ||
112848 | 87757 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 375 Diamond St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50411 | 6001812 | 2103665 | 37.7563655677175 | -122.436722244288 | (37.7563655677175, -122.436722244288) | 2 | 4 | 5 | 28862 | 3 | |||
113367 | 42063 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3125 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/2001 12:00:00 AM | Permit Number 44019 | 6008884.76165611 | 2100531.31488982 | 37.7481605856471 | -122.412040626823 | (37.7481605856471, -122.412040626823) | 2 | 4 | 7 | 28859 | 2 | ||
113833 | 62113 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3435 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1985 12:00:00 AM | Permit Number 22214 | 6006889.06228658 | 2101433.18572997 | 37.7505247436869 | -122.419005662389 | (37.7505247436869, -122.419005662389) | 2 | 4 | 7 | 28859 | 19 | ||
114043 | 67041 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3862 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1992 12:00:00 AM | Permit Number 30420 | 6002678.14449025 | 2103591.98537254 | 37.7562142727984 | -122.433721599504 | (37.7562142727984, -122.433721599504) | 2 | 4 | 5 | 28862 | 3 | ||
116048 | 62104 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 428-430 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2016 12:00:00 AM | 3x3 | Permit Number 22197 | 6006759.20921855 | 2101277.45117643 | 37.7500898190298 | -122.419443658065 | (37.7500898190298, -122.419443658065) | 2 | 4 | 7 | 28859 | 19 | |
116525 | 67243 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4356 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/1992 12:00:00 AM | Permit Number 30707 | 6001601.68859184 | 2100608.05575584 | 37.7479599763382 | -122.437230700083 | (37.7479599763382, -122.437230700083) | 2 | 4 | 5 | 28862 | 22 | ||
119604 | 50063 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 259 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46792 | 6004623.22870051 | 2103939.22214247 | 37.7572778811094 | -122.427019561527 | (37.7572778811094, -122.427019561527) | 2 | 4 | 5 | 28862 | 3 | ||
122980 | 107236 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 3326 23RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2015 12:00:00 AM | Permit Number 775776 | 6006851 | 2102663.4 | 37.7539004875763 | -122.419224541208 | (37.7539004875763, -122.419224541208) | 2 | 4 | 7 | 28859 | 19 | |||
124282 | 35298 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4128 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/1998 12:00:00 AM | Permit Number 38772 | 6002342.17007059 | 2101820.0635556 | 37.7513299284774 | -122.434756807393 | (37.7513299284774, -122.434756807393) | 2 | 4 | 5 | 28862 | 22 | |||
128906 | 37406 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1710 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45479 | 6002579.2352778 | 2100599.04049757 | 37.7479907436881 | -122.433849744568 | (37.7479907436881, -122.433849744568) | 2 | 4 | 5 | 63 | 22 | ||
131404 | 62103 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 437 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1985 12:00:00 AM | Permit Number 22196 | 6006813.60805899 | 2101235.59554089 | 37.7499779567927 | -122.419252574646 | (37.7499779567927, -122.419252574646) | 2 | 4 | 7 | 28859 | 19 | ||
131699 | 42906 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3270 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42819 | 6008379.96600066 | 2104491.21306208 | 37.7590052357633 | -122.414066301806 | (37.7590052357633, -122.414066301806) | 2 | 4 | 7 | 28859 | 19 | ||
131944 | 38317 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 774280 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.413465790173 | (37.7684292621485, -122.413465790173) | 8 | 4 | 7 | 28853 | 19 | |
134509 | 80153 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4675-4677 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 3x3 | Permit Number 50049 | 6000057.47834609 | 2105146.79504317 | 37.7603343454923 | -122.442896377988 | (37.7603343454923, -122.442896377988) | 2 | 4 | 5 | 28862 | 3 | ||
138809 | 38321 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | Permit Number 774280 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.413465790173 | (37.7684292621485, -122.413465790173) | 8 | 4 | 7 | 28853 | 19 | |||
140538 | 62115 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 455 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1985 12:00:00 AM | Permit Number 22217 | 6006819.18462488 | 2101134.94773993 | 37.7497019148816 | -122.419226151887 | (37.7497019148816, -122.419226151887) | 2 | 4 | 7 | 28859 | 19 | ||
145479 | 96592 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
146237 | 35565 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1021 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2003 12:00:00 AM | Permit Number 38935 | 6005771.77167049 | 2102851.56857317 | 37.7543563162185 | -122.422970143174 | (37.7543563162185, -122.422970143174) | 2 | 4 | 5 | 28859 | 19 | ||
147036 | 33049 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1259 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37325 | 6005839.09502219 | 2101642.93131356 | 37.7510414759561 | -122.422651438228 | (37.7510414759561, -122.422651438228) | 2 | 4 | 5 | 28859 | 19 | ||
147222 | 62109 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 324 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1985 12:00:00 AM | Permit Number 22203 | 6006724.68282258 | 2101882.72153367 | 37.7517498086248 | -122.419605991235 | (37.7517498086248, -122.419605991235) | 2 | 4 | 7 | 28859 | 19 | ||
147358 | 104643 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 290X Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769396 | 6006718.6 | 2102097 | 37.7523378256517 | -122.419642228322 | (37.7523378256517, -122.419642228322) | 2 | 4 | 7 | 28859 | 19 | |||
147933 | 68475 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 898x HAMPSHIRE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1993 12:00:00 AM | Permit Number 32344 | 6010178 | 2104272 | 37.7585041507506 | -122.407832365849 | (37.7585041507506, -122.407832365849) | 10 | 4 | 7 | 28859 | 19 | |||
150294 | 39316 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3248 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40892 | 6007145.08024569 | 2106178.91659474 | 37.7635698413851 | -122.418456799551 | (37.7635698413851, -122.418456799551) | 8 | 4 | 7 | 28859 | 19 | ||
153178 | 39315 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3248 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40892 | 6007145.08024569 | 2106178.91659474 | 37.7635698413851 | -122.418456799551 | (37.7635698413851, -122.418456799551) | 8 | 4 | 7 | 28859 | 19 | ||
155063 | 66518 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 811 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1991 12:00:00 AM | Permit Number 29686 | 6001320.92036786 | 2099966.32859782 | 37.7461819814772 | -122.438155619166 | (37.7461819814772, -122.438155619166) | 2 | 4 | 5 | 63 | 22 | ||
156111 | 96589 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
156421 | 50409 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1023 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2003 12:00:00 AM | Permit Number 47064 | 6005772.16397035 | 2102844.45984762 | 37.7543368194422 | -122.422968281285 | (37.7543368194422, -122.422968281285) | 2 | 4 | 5 | 28859 | 19 | |||
162179 | 85184 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 501 Bartlett St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/13/2006 12:00:00 AM | 3x25 | Permit Number 768657 | 6006822 | 2100867 | 37.7489663498096 | -122.419197411761 | (37.7489663498096, -122.419197411761) | 2 | 4 | 7 | 28859 | 19 | |||
162676 | 50064 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 259 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46792 | 6004623.22870051 | 2103939.22214247 | 37.7572778811094 | -122.427019561527 | (37.7572778811094, -122.427019561527) | 2 | 4 | 5 | 28862 | 3 | ||
165847 | 64320 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4124 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25143 | 6003075.78570292 | 2100689.05530628 | 37.7482660683857 | -122.432139122078 | (37.7482660683857, -122.432139122078) | 2 | 4 | 5 | 28862 | 22 | ||
167099 | 54591 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 202 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/2001 12:00:00 AM | Permit Number 10414 | 6004100.19857146 | 2102151.84931985 | 37.7523405869325 | -122.428700992754 | (37.7523405869325, -122.428700992754) | 2 | 4 | 5 | 28862 | 22 | ||
173521 | 99792 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4120-4124 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 6002399 | 2101817 | 37.7513247429435 | -122.434560064215 | (37.7513247429435, -122.434560064215) | 2 | 4 | 5 | 28862 | 22 | ||||
174740 | 62119 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 385 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1985 12:00:00 AM | Permit Number 22221 | 6006795.95615194 | 2101550.2125238 | 37.7508408292352 | -122.419335932156 | (37.7508408292352, -122.419335932156) | 2 | 4 | 7 | 28859 | 19 | ||
174869 | 30873 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3881 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34707 | 6004466.82267682 | 2104222.01878233 | 37.7580455284889 | -122.427580622152 | (37.7580455284889, -122.427580622152) | 2 | 4 | 5 | 28862 | 3 | |||
176122 | 253851 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825X Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6008234 | 2102998 | 37.7548970135718 | -122.414465463083 | (37.7548970135718, -122.414465463083) | 2 | 4 | 7 | 28859 | 19 | ||||
178775 | 42945 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 54 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42840 | 6007765.38854271 | 2106161.17113141 | 37.7635560172004 | -122.416310086241 | (37.7635560172004, -122.416310086241) | 8 | 4 | 7 | 28859 | 19 | ||
180290 | 57672 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 258 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 16574 | 6002046.95980661 | 2104357.19731056 | 37.758279524896 | -122.435959200471 | (37.758279524896, -122.435959200471) | 2 | 4 | 5 | 28862 | 3 | ||
181338 | 33036 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 494 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37315 | 6006779.65662971 | 2100908.40918731 | 37.7490776652966 | -122.41934677281 | (37.7490776652966, -122.41934677281) | 2 | 4 | 7 | 28859 | 19 | |||
183152 | 33018 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3638 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37306 | 6005540.00148664 | 2101997.41979374 | 37.7519979406206 | -122.423710937024 | (37.7519979406206, -122.423710937024) | 2 | 4 | 5 | 28859 | 19 | ||
183650 | 47558 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 206 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45420 | 6004100.72419306 | 2102141.4355601 | 37.7523120229359 | -122.428698432782 | (37.7523120229359, -122.428698432782) | 2 | 4 | 5 | 28862 | 22 | ||
188702 | 65262 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1175 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28063 | 6009506.97444582 | 2102339.79830216 | 37.7531611699928 | -122.410016678829 | (37.7531611699928, -122.410016678829) | 2 | 4 | 7 | 28859 | 19 | ||
189798 | 62105 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 421 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1985 12:00:00 AM | Permit Number 22198 | 6006808.65111019 | 2101325.06027725 | 37.7502233274314 | -122.419276061715 | (37.7502233274314, -122.419276061715) | 2 | 4 | 7 | 28859 | 19 | ||
192414 | 60717 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 41 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1983 12:00:00 AM | Permit Number 20370 | 6005271.64346124 | 2105221.71929321 | 37.7608359608708 | -122.424868327925 | (37.7608359608708, -122.424868327925) | 2 | 4 | 5 | 28859 | 19 | |||
192566 | 64406 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2427 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/1988 12:00:00 AM | Permit Number 25251 | 6011317.18902428 | 2102741.84827953 | 37.7543664024991 | -122.403784849219 | (37.7543664024991, -122.403784849219) | 10 | 4 | 8 | 28859 | 19 | |||
194197 | 32843 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 838 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37197 | 6001875.52927375 | 2101649.48990957 | 37.7508350700837 | -122.43635829546 | (37.7508350700837, -122.43635829546) | 2 | 4 | 5 | 28862 | 22 | ||
105783 | 243307 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 590 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/1976 12:00:00 AM | 0 | Width 3ft | 6007430.34748 | 2106243.87464 | 37.7637642560428 | -122.417474751767 | (37.7637642560428, -122.417474751767) | 8 | 4 | 7 | 28859 | 19 | ||
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 | |||
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 | |||
24237 | 223512 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007094.15413 | 2105540.45939 | 37.7618139197035 | -122.418587660093 | (37.7618139197035, -122.418587660093) | 2 | 4 | 7 | 28859 | 19 | |||
39722 | 223593 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 930 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009378.63549 | 2103724.24958 | 37.756955368323 | -122.41055825836 | (37.756955368323, -122.41055825836) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
47083 | 224046 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 208 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5999979.04483 | 2104876.63266 | 37.7595880742544 | -122.443148238699 | (37.7595880742544, -122.443148238699) | 2 | 4 | 5 | 28862 | 3 | |||
54927 | 223447 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1261 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003898.74209 | 2100909.80549 | 37.7489188214426 | -122.429309101453 | (37.7489188214426, -122.429309101453) | 2 | 4 | 5 | 28862 | 22 |
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) );