trees

348 rows where Police Districts = 4 and qSpecies_id = 8 sorted by Supervisor Districts

✎ View and edit SQL

This data as json, CSV (advanced)

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)
893 226590 Private 9 Eriobotrya deflexa :: Bronze Loquat 8 837 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 Port 08/14/2019 12:00:00 AM 3 3x3 Permit Number 784594 6001099.54842 2099653.23365 37.7453097044788 -122.438898660558 (37.7453097044788, -122.438898660558) 2 4 5 63 22
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
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
2915 223666 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1511 Castro St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4   02/16/2016 05:50:00 AM 2 Width 3ft   6002610.0457 2101075.27233 37.7493001124297 -122.433777236447 (37.7493001124297, -122.433777236447) 2 4 5 28862 22
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
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
5373 224056 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 4609 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2020 12:00:00 AM 3 Width 3ft Permit Number 787677 6000381.16624 2105168.69891 37.7604129369301 -122.441778467817 (37.7604129369301, -122.441778467817) 2 4 5 28862 3
7811 10192 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1169 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/16/2016 04:46:00 AM 3 3X3   6005805.59526 2102140.15786 37.7524048554241 -122.422802617046 (37.7524048554241, -122.422802617046) 2 4 5 28859 19
8807 224036 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1511 Castro St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/16/2016 07:10:00 AM 2 Width 3ft   6002606.66337 2101060.9954 37.7492607194187 -122.433787912303 (37.7492607194187, -122.433787912303) 2 4 5 28862 22
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
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
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
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
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
14883 242086 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4185 25th St 12 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   02/16/2016 05:57:00 AM 2 Width 3ft   6002948.22198 2101215.85126 37.7497052929799 -122.432617857444 (37.7497052929799, -122.432617857444) 2 4 5 28862 22
15080 223395 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3641 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6005336.13601 2104859.99107 37.7598463829262 -122.424619544351 (37.7598463829262, -122.424619544351) 2 4 5 28859 19
15659 26852 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1201 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   07/19/2016 05:13:00 AM 3 2X2   6005817.98305 2101925.96787 37.7518174380456 -122.422744557734 (37.7518174380456, -122.422744557734) 2 4 5 28859 19
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
21456 34943 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3968 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2016 12:00:00 AM 3   Permit Number 775333 6003347.35755113 2102457.99102165 37.7531385434777 -122.43132628846 (37.7531385434777, -122.43132628846) 2 4 5 28862 22
21897 223405 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 201 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6005449.32896 2102471.93612 37.7532957337303 -122.424058237901 (37.7532957337303, -122.424058237901) 2 4 5 28859 19
22090 224049 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 260 Collingwood St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002051.64145 2104349.66378 37.7582591055966 -122.435942470278 (37.7582591055966, -122.435942470278) 2 4 5 28862 3
22315 113814 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 02/16/2016 06:05:00 AM 3 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
25072 223529 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 4175 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002046.64832 2102339.03335 37.7527381135931 -122.435815881724 (37.7527381135931, -122.435815881724) 2 4 5 28862 22
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
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
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
34878 224062 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 67 Landers St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004498.44679 2107387.20492 37.7667381638479 -122.427696765417 (37.7667381638479, -122.427696765417) 8 4 5 28862 3
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
35182 224055 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3810 20th St 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   6004350.69854 2104285.65184 37.7582136808258 -122.427986763479 (37.7582136808258, -122.427986763479) 2 4 5 28862 3
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
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
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
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
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
54683 223522 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 811 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6001294.89764 2099975.47242 37.7462056082153 -122.438246257254 (37.7462056082153, -122.438246257254) 2 4 5 63 22
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
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
57602 223527 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 647 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002187.40945 2102635.29602 37.7535595750195 -122.435350295491 (37.7535595750195, -122.435350295491) 2 4 5 28862 22
58200 223663 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 838 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/1996 12:00:00 AM 8 Width 3ft Permit Number 37197 6001879.47646 2101560.46909 37.750590864394 -122.436338275392 (37.750590864394, -122.436338275392) 2 4 5 28862 22
59728 223664 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 730 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6001679.46689 2102069.69668 37.7519777151979 -122.437066377309 (37.7519777151979, -122.437066377309) 2 4 5 28862 22
60745 223399 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3438 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005409.07211 2103737.92814 37.7567695800561 -122.424287488577 (37.7567695800561, -122.424287488577) 2 4 5 28859 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
64267 109098 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 442 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 774790 6003487.8 2102768.8 37.7539999097808 -122.430862790198 (37.7539999097808, -122.430862790198) 2 4 5 28862 22
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
69745 223394 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 29 Oakwood St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6005256.12895 2105270.01288 37.76096768734 -122.424925421792 (37.76096768734, -122.424925421792) 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
73679 224048 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 395 Diamond St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001818.32693 2103639.30032 37.7562953621538 -122.436698524039 (37.7562953621538, -122.436698524039) 2 4 5 28862 3
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
75331 224051 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3866 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002622.24205 2103582.54742 37.7561851862111 -122.433914254443 (37.7561851862111, -122.433914254443) 2 4 5 28862 3
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
79010 223385 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3667 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6005189.30238 2104853.5381 37.7598203709419 -122.4251269113 (37.7598203709419, -122.4251269113) 2 4 5 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
83988 224045 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 118 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6000330.71148 2104908.09647 37.7596945117222 -122.441934261878 (37.7596945117222, -122.441934261878) 2 4 5 28862 3
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
86041 224052 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 259 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6004554.98414 2103937.91875 37.7572704430872 -122.427255485157 (37.7572704430872, -122.427255485157) 2 4 5 28862 3
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
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
86846 254804 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1159 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/28/2018 12:00:00 AM 3 3x3 Permit Number 778103 6004469.23164 2102144.01452 37.7523399531709 -122.427424258339 (37.7523399531709, -122.427424258339) 2 4 5 28862 22
87336 113817 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 10 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 02/16/2016 06:00:00 AM 3 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
88033 109232 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 307 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/04/2015 12:00:00 AM 3 3x3 Permit Number 773233 6004826.5 2101863.3 37.7515893763796 -122.426168783014 (37.7515893763796, -122.426168783014) 2 4 5 28862 22
88456 113809 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 06/15/2016 07:36:00 AM 3 5x5   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
88478 234149 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3652 23rd St 5 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6005288.48907 2102558.72214 37.753524945734 -122.424620628936 (37.753524945734, -122.424620628936) 2 4 5 28859 19
88812 224047 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 199 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6000037.0409 2104849.58575 37.7595171168378 -122.442945717669 (37.7595171168378, -122.442945717669) 2 4 5 28862 3
89093 223393 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 29 Oakwood St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6005258.03741 2105246.60888 37.7609035332795 -122.424917156109 (37.7609035332795, -122.424917156109) 2 4 5 28859 19
89644 223402 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3600 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6005679.72698 2101995.97902 37.7520018710012 -122.423227642937 (37.7520018710012, -122.423227642937) 2 4 5 28859 19
90434 113818 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 11 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 02/16/2016 05:57:00 AM 3 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 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
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
94830 224057 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 4677 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6000058.79012 2105152.70486 37.7603506471783 -122.442892265582 (37.7603506471783, -122.442892265582) 2 4 5 28862 3
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
99219 4397 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1011 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004431.54351 2102978.61798 37.7546294472032 -122.427614046667 (37.7546294472032, -122.427614046667) 2 4 5 28862 22
99752 224039 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 442 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6003480.14562 2102754.58142 37.7539604352279 -122.430888246193 (37.7539604352279, -122.430888246193) 2 4 5 28862 22
100895 223528 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 4179 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6002019.36916 2102337.8654 37.7527333570666 -122.435910134258 (37.7527333570666, -122.435910134258) 2 4 5 28862 22
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
101627 116814 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3660x 23RD ST 5 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2016 12:00:00 AM 3 3x3 Permit Number 779082 6005401 2102665 37.7538231135776 -122.42423909942 (37.7538231135776, -122.42423909942) 2 4 5 28859 19
102089 223398 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3624 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6006084.73397 2104359.22358 37.7585136416007 -122.421994932341 (37.7585136416007, -122.421994932341) 2 4 5 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
108687 224097 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1414 Castro St 1 Sidewalk: Curb side : Pot Tree Private 2     9 Width 3ft   6002522.98232 2101416.25277 37.7502314233618 -122.434102675005 (37.7502314233618, -122.434102675005) 2 4 5 28862 22
109496 224044 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 4723 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 6x4   6000124.85335 2104609.2479 37.7588622143265 -122.442624763133 (37.7588622143265, -122.442624763133) 2 4 5 28862 3
110883 27510 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1259 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 2X2   6005834.02618 2101632.44152 37.7510123874197 -122.422668221463 (37.7510123874197, -122.422668221463) 2 4 5 28859 19
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
113175 224040 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3968 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6003356.28617 2102454.69012 37.7531299859864 -122.431295175934 (37.7531299859864, -122.431295175934) 2 4 5 28862 22
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
116053 223541 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 814 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6001016.96065 2102616.12439 37.7534403941744 -122.439396579213 (37.7534403941744, -122.439396579213) 2 4 5 28862 22
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
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
118346 105752 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 67 LANDERS ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6004519.3 2107402.1 37.7667802417179 -122.427625698984 (37.7667802417179, -122.427625698984) 8 4 5 28862 3
118438 224053 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 259 Liberty St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004575.93816 2103937.48718 37.7572704430928 -122.427182987199 (37.7572704430928, -122.427182987199) 2 4 5 28862 3
118992 223526 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 4128 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6002300.13166 2101812.63731 37.7513071510194 -122.434901649798 (37.7513071510194, -122.434901649798) 2 4 5 28862 22
119594 10207 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1273 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 2X2   6005836.97194 2101563.95801 37.7508245136462 -122.422653168634 (37.7508245136462, -122.422653168634) 2 4 5 28859 19
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
122152 223515 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 85 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005792.03644 2102839.8234 37.7543252101645 -122.422899227642 (37.7543252101645, -122.422899227642) 2 4 5 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);