trees
969 rows where qSpecies_id = 97 sorted by SiteOrder descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23053 | 48044 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
31709 | 224519 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007848.49243 | 2105359.1644 | 37.7613585650588 | -122.415965857533 | (37.7613585650588, -122.415965857533) | 2 | 4 | 7 | 28859 | 19 | |||
64627 | 34152 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
130469 | 224509 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2225 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008178.36373 | 2105370.35117 | 37.76140782184 | -122.414825759103 | (37.76140782184, -122.414825759103) | 2 | 4 | 7 | 28859 | 19 | |||
138904 | 226480 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3160 19th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008258.38904 | 2105066.62295 | 37.7605783501336 | -122.414527490854 | (37.7605783501336, -122.414527490854) | 2 | 4 | 7 | 28859 | 19 | |||
141866 | 226497 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1850 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008687.35447 | 2107561.73783 | 37.7674534504487 | -122.41322033256 | (37.7674534504487, -122.41322033256) | 8 | 4 | 7 | 28853 | 19 | |||
143067 | 122749 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 6011285.50671 | 2105214.92948 | 37.7611551645106 | -122.404068449214 | (37.7611551645106, -122.404068449214) | 10 | 3 | 8 | 28856 | 29 | |||
171805 | 115033 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
184443 | 224505 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2200 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008118.04648 | 2105348.76718 | 37.7613451678544 | -122.415032844197 | (37.7613451678544, -122.415032844197) | 2 | 4 | 7 | 28859 | 19 | |||
7782 | 101433 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
22276 | 224570 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 18th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007990.36824 | 2105589.83292 | 37.7619999031047 | -122.415491498431 | (37.7619999031047, -122.415491498431) | 2 | 4 | 7 | 28859 | 19 | |||
59644 | 224508 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2225 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6008177.84488 | 2105327.19464 | 37.761289294789 | -122.414824499172 | (37.761289294789, -122.414824499172) | 2 | 4 | 7 | 28859 | 19 | |||
62255 | 226479 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3160 19th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6008278.21403 | 2105065.65299 | 37.7605768005893 | -122.414458856385 | (37.7605768005893, -122.414458856385) | 2 | 4 | 7 | 28859 | 19 | |||
76052 | 48037 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
96286 | 224518 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007850.1916 | 2105341.72368 | 37.7613107723984 | -122.415958745694 | (37.7613107723984, -122.415958745694) | 2 | 4 | 7 | 28859 | 19 | |||
117473 | 115032 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
122926 | 122750 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 6011285.1392 | 2105241.40164 | 37.7612278306072 | -122.404071583333 | (37.7612278306072, -122.404071583333) | 10 | 3 | 8 | 28856 | 29 | |||
127678 | 226498 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1850 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008688.72129 | 2107547.38011 | 37.7674141042173 | -122.413214589496 | (37.7674141042173, -122.413214589496) | 8 | 4 | 7 | 28853 | 19 | |||
171989 | 34145 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
5167 | 126631 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 7 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6013670.6132 | 2118002.84349 | 37.796400840179 | -122.39671583859 | (37.796400840179, -122.39671583859) | 3 | 1 | 10 | 28860 | 6 | |||
23203 | 6798 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1375 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x9 | 6016915.23611 | 2097187.56543 | 37.7394266247399 | -122.384038431137 | (37.7394266247399, -122.384038431137) | 10 | 3 | 8 | 58 | 1 | |||
69695 | 226478 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3160 19th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6008300.96502 | 2105069.13983 | 37.7605876527244 | -122.41438041754 | (37.7605876527244, -122.41438041754) | 2 | 4 | 7 | 28859 | 19 | |||
91606 | 224569 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 18th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007968.16087 | 2105588.52083 | 37.7619950521511 | -122.415568212409 | (37.7619950521511, -122.415568212409) | 2 | 4 | 7 | 28859 | 19 | |||
97902 | 48043 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
101534 | 224552 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3381 20th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007727.86688 | 2104411.29924 | 37.7587491632507 | -122.416315914159 | (37.7587491632507, -122.416315914159) | 2 | 4 | 7 | 28859 | 19 | |||
115580 | 36099 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 299 on 16th Dolores St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1998 12:00:00 AM | Permit Number 39198 | 6004891.74541508 | 2106619.46330166 | 37.7646523685012 | -122.426281744676 | (37.7646523685012, -122.426281744676) | 8 | 4 | 5 | 28859 | 19 | |||
122705 | 115031 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
137057 | 224517 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007852.87657 | 2105322.21505 | 37.7612573571568 | -122.415948077947 | (37.7612573571568, -122.415948077947) | 2 | 4 | 7 | 28859 | 19 | |||
175405 | 176404 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 332 Ellington Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5998751.95541 | 2087834.14028 | 37.712723399629 | -122.446166209719 | (37.712723399629, -122.446166209719) | 9 | 7 | 6 | 28861 | 25 | |||
179766 | 34151 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
186379 | 101432 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
36236 | 48046 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
36749 | 122752 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 6011278.80569 | 2105286.3398 | 37.7613508668666 | -122.404096651066 | (37.7613508668666, -122.404096651066) | 10 | 3 | 8 | 28856 | 29 | |||
39551 | 39879 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 301 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | |||
41759 | 30892 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Hayes St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | 7 | 9 | 11 | 28852 | 10 | |||
54721 | 224580 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | Permit Number 781047 | 6008616.55983 | 2106802.76672 | 37.7653655169234 | -122.413411521233 | (37.7653655169234, -122.413411521233) | 8 | 4 | 7 | 28859 | 19 | ||
65251 | 116393 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | ||||
73416 | 101431 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
77132 | 184317 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1557 39th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5984033.1876 | 2104377.9194 | 37.7572966221146 | -122.498259277429 | (37.7572966221146, -122.498259277429) | 1 | 8 | 3 | 56 | 35 | |||
101195 | 226473 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3101 19th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008617.67732 | 2105085.24659 | 37.7606496645635 | -122.413286189004 | (37.7606496645635, -122.413286189004) | 2 | 4 | 7 | 28859 | 19 | |||
106151 | 126625 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1445 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6011819.79643 | 2120570.04508 | 37.8033465696629 | -122.403300781611 | (37.8033465696629, -122.403300781611) | 3 | 1 | 10 | 28860 | 6 | |||
108990 | 34150 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
117537 | 226477 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3160 19th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008318.01409 | 2105071.04935 | 37.7605938535523 | -122.414321587482 | (37.7605938535523, -122.414321587482) | 2 | 4 | 7 | 28859 | 19 | |||
125933 | 250314 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995896.25125 | 2115871.75264 | 37.7895441427054 | -122.458064218812 | (37.7895441427054, -122.458064218812) | 11 | 6 | 1 | 54 | 31 | |||
132591 | 115030 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
145617 | 126630 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 6 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 6013712.21512 | 2118015.33042 | 37.7964374416781 | -122.396572761821 | (37.7964374416781, -122.396572761821) | 3 | 1 | 10 | 28860 | 6 | |||
150027 | 126618 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3301 Van Ness Ave | 6 | : | Tree | Private 2 | 15 | Width 3ft | 6005157.45717 | 2122152.06561 | 37.8073160440754 | -122.426468777106 | (37.8073160440754, -122.426468777106) | 13 | 9 | 1 | 28858 | 17 | |||
159135 | 224542 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2925 21st St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008789.37213 | 2103883.03365 | 37.7573582996747 | -122.412607384336 | (37.7573582996747, -122.412607384336) | 2 | 4 | 7 | 28859 | 19 | |||
166304 | 224616 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 525 Burnett Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999502.23945 | 2102489.21916 | 37.7530056250346 | -122.444625668335 | (37.7530056250346, -122.444625668335) | 2 | 5 | 5 | 63 | 38 | |||
168838 | 84930 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1500@Polk Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||||
173490 | 224551 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3381 20th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007716.60877 | 2104410.35168 | 37.7587459283935 | -122.416354782871 | (37.7587459283935, -122.416354782871) | 2 | 4 | 7 | 28859 | 19 | |||
175731 | 224660 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 602 Alabama St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008966.98404 | 2105222.67226 | 37.7610466091319 | -122.41208780281 | (37.7610466091319, -122.41208780281) | 2 | 4 | 7 | 28859 | 19 | |||
8245 | 259048 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1x Otis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007165 | 2109609 | 37.7729891632586 | -122.418631158564 | (37.7729891632586, -122.418631158564) | 8 | 2 | 9 | 28853 | 19 | ||||
22488 | 98718 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1500@Polk Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||||
30771 | 101430 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
38685 | 224661 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 602 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6008966.38412 | 2105242.83972 | 37.7611019507102 | -122.412091302998 | (37.7611019507102, -122.412091302998) | 2 | 4 | 7 | 28859 | 19 | |||
58028 | 48791 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
66329 | 108965 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 | ||||
72078 | 251012 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995905.52497 | 2115874.18508 | 37.7895513543625 | -122.458032309042 | (37.7895513543625, -122.458032309042) | 11 | 6 | 1 | 54 | 31 | |||
74671 | 116392 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | ||||
80194 | 224568 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007934.38254 | 2105585.38385 | 37.7619845399816 | -122.415684816721 | (37.7619845399816, -122.415684816721) | 2 | 4 | 7 | 28859 | 19 | |||
82252 | 48042 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
83060 | 224550 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3381 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007700.02344 | 2104409.21878 | 37.7587418850474 | -122.416412062475 | (37.7587418850474, -122.416412062475) | 2 | 4 | 7 | 28859 | 19 | |||
83716 | 114018 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 800x ALABAMA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | ||||
88021 | 115029 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
95322 | 39878 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 301 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | |||
108948 | 30891 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | 7 | 9 | 11 | 28852 | 10 | |||
112805 | 224672 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 800 Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009346.52184 | 2104406.68388 | 37.7588273781878 | -122.410717513006 | (37.7588273781878, -122.410717513006) | 2 | 4 | 7 | 28859 | 19 | |||
114822 | 97313 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 926 Taraval St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/1984 12:00:00 AM | 3x3 | 5990372 | 2099065 | 37.7430783865792 | -122.475949404311 | (37.7430783865792, -122.475949404311) | 1 | 8 | 3 | 29491 | 35 | |||
148502 | 224692 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3514 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006331.52942 | 2101449.49488 | 37.7505381137462 | -122.420934815082 | (37.7505381137462, -122.420934815082) | 2 | 4 | 5 | 28859 | 19 | |||
149080 | 251397 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 311 Townsend St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6013957 | 2110872 | 37.776837125863 | -122.395225113019 | (37.776837125863, -122.395225113019) | 6 | 2 | 9 | 28856 | 20 | ||||
156229 | 226472 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3101 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008660.80856 | 2105087.18769 | 37.7606574158171 | -122.413137154278 | (37.7606574158171, -122.413137154278) | 2 | 4 | 7 | 28859 | 19 | |||
165009 | 226476 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3160 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008336.71685 | 2105070.66673 | 37.7605938535513 | -122.414256875855 | (37.7605938535513, -122.414256875855) | 2 | 4 | 7 | 28859 | 19 | |||
177108 | 34149 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
183797 | 224615 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 525 Burnett Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999500.0818 | 2102479.17274 | 37.7529779168973 | -122.444632407852 | (37.7529779168973, -122.444632407852) | 2 | 5 | 5 | 63 | 38 | |||
193316 | 224541 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2925 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008764.83764 | 2103880.48748 | 37.7573499314791 | -122.412692054597 | (37.7573499314791, -122.412692054597) | 2 | 4 | 7 | 28859 | 19 | |||
7593 | 224702 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3236 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 3ft | 6007468.55757 | 2102099.56491 | 37.7523870848126 | -122.417048929078 | (37.7523870848126, -122.417048929078) | 2 | 4 | 7 | 28859 | 19 | |||
9589 | 243519 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3283 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6007186.6119 | 2102035.21074 | 37.7521945183717 | -122.418019383909 | (37.7521945183717, -122.418019383909) | 2 | 4 | 7 | 28859 | 19 | |||
10424 | 259047 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1x Otis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007165 | 2109609 | 37.7729891632586 | -122.418631158564 | (37.7729891632586, -122.418631158564) | 8 | 2 | 9 | 28853 | 19 | ||||
16046 | 99287 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2839 Pacific Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6000564.2 | 2116779 | 37.7923023065947 | -122.44197880494 | (37.7923023065947, -122.44197880494) | 13 | 6 | 1 | 29490 | 27 | |||||
20417 | 224687 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3513 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006398.66183 | 2101411.28771 | 37.7504369894718 | -122.420699953558 | (37.7504369894718, -122.420699953558) | 2 | 4 | 5 | 28859 | 19 | |||
27966 | 173643 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 657 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012793 | 2114089 | 37.7856054636163 | -122.399477673173 | (37.7856054636163, -122.399477673173) | 6 | 2 | 9 | 28853 | 6 | ||||
37941 | 184315 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1557 39th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5984032.5928 | 2104430.6415 | 37.7574413473895 | -122.498265228241 | (37.7574413473895, -122.498265228241) | 1 | 8 | 3 | 56 | 35 | |||
43225 | 249547 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 298 Myrtle St | 4 | : | Tree | Private 2 | 15 | Width 3ft | 6006068.98024 | 2114032.12876 | 37.7850722314402 | -122.422736821748 | (37.7850722314402, -122.422736821748) | 13 | 9 | 11 | 28858 | 41 | |||
45618 | 30532 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1020 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.77681277294 | -122.404779881684 | (37.77681277294, -122.404779881684) | 14 | 2 | 9 | 28853 | 34 | |||
47523 | 75088 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 574 WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/1985 12:00:00 AM | 18 | 5x5 | 6002936 | 2108949 | 37.7709379654477 | -122.433212606655 | (37.7709379654477, -122.433212606655) | 15 | 5 | 11 | 29492 | 9 | ||
47706 | 176411 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 60 Onondaga Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000874.43024 | 2091115.97701 | 37.7218555689538 | -122.439065336396 | (37.7218555689538, -122.439065336396) | 9 | 7 | 6 | 28861 | 25 | |||
49127 | 34147 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
51336 | 24449 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1156 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6006348.43077 | 2102831.95647 | 37.7543349884778 | -122.420974512988 | (37.7543349884778, -122.420974512988) | 2 | 4 | 5 | 28859 | 19 | |||
54673 | 224671 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 800 Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009345.91132 | 2104426.34813 | 37.758881337533 | -122.410721013192 | (37.758881337533, -122.410721013192) | 2 | 4 | 7 | 28859 | 19 | |||
64252 | 224549 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3381 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007677.21195 | 2104407.32973 | 37.7587354153184 | -122.416490821491 | (37.7587354153184, -122.416490821491) | 2 | 4 | 7 | 28859 | 19 | |||
67261 | 224653 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 44 Elsie St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6007416.47838 | 2099024.91557 | 37.7439418608428 | -122.417011196208 | (37.7439418608428, -122.417011196208) | 2 | 7 | 7 | 28859 | 2 | |||
73159 | 218834 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991139.93283 | 2098423.38649 | 37.7413611770786 | -122.473247341618 | (37.7413611770786, -122.473247341618) | 1 | 8 | 4 | 29491 | 40 | |||
74295 | 97191 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 255 California St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | 4 | 1 | 10 | 28860 | 6 | |||
78946 | 226484 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3120 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6008470.16955 | 2105663.03593 | 37.7622278587398 | -122.413837225211 | (37.7622278587398, -122.413837225211) | 8 | 4 | 7 | 28859 | 19 | |||
79503 | 656 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3255X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 12 | 4x4 | 6007336.00672 | 2102041.77073 | 37.7522209377618 | -122.417503217111 | (37.7522209377618, -122.417503217111) | 2 | 4 | 7 | 28859 | 19 | |||
83507 | 98238 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1299X 09th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 32025 | 5993314 | 2106663 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | 11 | 8 | 11 | 56 | 12 | ||||
91578 | 97725 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 4 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | |||
92990 | 114017 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 800x ALABAMA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | ||||
102943 | 100479 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 340 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 781547 | 6009830.08403 | 2114659.89537 | 37.7870074133103 | -122.409768858656 | (37.7870074133103, -122.409768858656) | 5 | 10 | 10 | 28852 | 36 |
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) );