trees

963 rows where qCaretaker_id = 2 and qSpecies_id = 53 sorted by Fire Prevention Districts

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Private · 963 ✖
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)
4983 112267 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2                              
6288 254356 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 3 Sidewalk: Curb side : Cutout Tree Private 2 DPW                            
9010 253870 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW       Tree is at very corner of Otis and Mission; at 12 St and S Van Ness Intersection                    
11335 112269 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 3 Sidewalk: Curb side : Cutout Tree Private 2                              
17892 254355 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW                            
18422 112268 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2                              
35372 94058 Undocumented 4 Ficus nitida :: Laurel Fig 53 1401X 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5993648 2105942 37.7621502689837 -122.465121353228 (37.7621502689837, -122.465121353228) 1 8 11 56 12
79333 33008 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1311 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM   6x4 Permit Number 37302 5994224.05093468 2106581.50911401 37.7639393951455 -122.463175433011 (37.7639393951455, -122.463175433011) 1 5 11 56 12
118732 117200 Undocumented 4 Ficus nitida :: Laurel Fig 53 1321 23RD AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5988915 2106334 37.7629525336189 -122.481519510385 (37.7629525336189, -122.481519510385) 1 8 3 56 35
140944 54742 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1374 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/1972 12:00:00 AM   3x3 Permit Number 10588 5993980.75543943 2106156.09216002 37.7627572927027 -122.463986029849 (37.7627572927027, -122.463986029849) 1 5 11 56 12
153860 94059 Undocumented 4 Ficus nitida :: Laurel Fig 53 1401X 08th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5993648 2105942 37.7621502689837 -122.465121353228 (37.7621502689837, -122.465121353228) 1 8 11 56 12
16900 485 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2706 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6010468.2249 2102315.41281 37.7531480416193 -122.406690748371 (37.7531480416193, -122.406690748371) 10 4 7 28859 19
18675 101715 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
19076 99594 Undocumented 4 Ficus nitida :: Laurel Fig 53 1855X Evans Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6014349.8 2099426.2 37.7454312840379 -122.393065244865 (37.7454312840379, -122.393065244865) 10 3 8 58 1
43224 117205 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2           6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29
54784 101716 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
56222 121122 Undocumented 4 Ficus nitida :: Laurel Fig 53 2701X 24th St 6 Sidewalk: Property side : Cutout Tree Private 2       3x3   6010429 2102109 37.7525790830309 -122.406811850318 (37.7525790830309, -122.406811850318) 10 4 7 28859 19
63265 6801 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1385 Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6016634.4993322 2097405.4643513 37.7400094064471 -122.385024282227 (37.7400094064471, -122.385024282227) 10 3 8 58 1
63978 119667 Undocumented 4 Ficus nitida :: Laurel Fig 53 699x Missouri St 8 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
64233 121118 Undocumented 4 Ficus nitida :: Laurel Fig 53 2701X 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010429 2102109 37.7525790830309 -122.406811850318 (37.7525790830309, -122.406811850318) 10 4 7 28859 19
64711 488 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2728 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6010357.12636 2102291.83707 37.7530770912847 -122.407073289419 (37.7530770912847, -122.407073289419) 10 4 7 28859 19
77226 121119 Undocumented 4 Ficus nitida :: Laurel Fig 53 2701X 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010429 2102109 37.7525790830309 -122.406811850318 (37.7525790830309, -122.406811850318) 10 4 7 28859 19
87085 101725 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 11 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
94460 101975 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1230 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769454 6013882 2105282.2 37.7614846061652 -122.395092936828 (37.7614846061652, -122.395092936828) 10 3 8 28856 29
100042 40805 Permitted Site 7 Ficus nitida :: Laurel Fig 53 585 Connecticut St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 41753 6013296.02646982 2104345.28151099 37.758879430057 -122.397053895785 (37.758879430057, -122.397053895785) 10 3 8 28856 29
101295 29407 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2801X Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3X3   6014804.18454 2090650.03815 37.7213589569903 -122.390880803843 (37.7213589569903, -122.390880803843) 10 3 8 58 1
105989 101717 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 3 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
106064 121117 Undocumented 4 Ficus nitida :: Laurel Fig 53 2701X 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6010429 2102109 37.7525790830309 -122.406811850318 (37.7525790830309, -122.406811850318) 10 4 7 28859 19
109428 116772 Undocumented 4 Ficus nitida :: Laurel Fig 53 376 MISSOURI ST 1 Sidewalk: Curb side : Cutout Tree Private 2       7x9   6013450 2105342 37.7616247710574 -122.396591249035 (37.7616247710574, -122.396591249035) 10 3 8 28856 29
121552 117206 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2           6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29
122922 99595 Undocumented 4 Ficus nitida :: Laurel Fig 53 1855X Evans Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6014349.8 2099426.2 37.7454312840379 -122.393065244865 (37.7454312840379, -122.393065244865) 10 3 8 58 1
131499 121120 Undocumented 4 Ficus nitida :: Laurel Fig 53 2701X 24th St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010429 2102109 37.7525790830309 -122.406811850318 (37.7525790830309, -122.406811850318) 10 4 7 28859 19
138070 101722 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 8 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
138887 101721 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 7 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
142433 486 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2708 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6010515.41751 2102258.44338 37.7529942564805 -122.406523532023 (37.7529942564805, -122.406523532023) 10 4 7 28859 19
143054 57622 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/15/1976 12:00:00 AM     Permit Number 16516 6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29
143637 101724 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 10 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
151070 121123 Undocumented 4 Ficus nitida :: Laurel Fig 53 2701X 24th St 7 Sidewalk: Property side : Cutout Tree Private 2     24 3x3   6010429 2102109 37.7525790830309 -122.406811850318 (37.7525790830309, -122.406811850318) 10 4 7 28859 19
158929 101720 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 6 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
169319 101719 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 5 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
176915 101718 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 4 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
179159 101726 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 12 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
3916 261241 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 840 El Camino Del Mar 1 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2020 12:00:00 AM 3 Width 4ft   5985843 2115056 37.786721565729 -122.492786794237 (37.786721565729, -122.492786794237) 11 6 1 55 33
8496 115992 Undocumented 4 Ficus nitida :: Laurel Fig 53 438 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2016 12:00:00 AM 3   Permit Number 778644 5989723.9 2112354.3 37.7795296278249 -122.479162248453 (37.7795296278249, -122.479162248453) 11 6 2 55 26
11487 260838 Significant Tree 6 Ficus nitida :: Laurel Fig 53 399 Laurel St 1 Side Yard : Cutout Tree Private 2       3x3   5998076 2115238 37.7879290262693 -122.45047684944 (37.7879290262693, -122.45047684944) 11 6 1 54 31
12511 260840 Significant Tree 6 Ficus nitida :: Laurel Fig 53 399 Laurel St 3 Side Yard : Cutout Tree Private 2       3x3   5998076 2115238 37.7879290262693 -122.45047684944 (37.7879290262693, -122.45047684944) 11 6 1 54 31
16842 261242 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 840 El Camino Del Mar 2 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2020 12:00:00 AM 3 Width 4ft   5985843 2115056 37.786721565729 -122.492786794237 (37.786721565729, -122.492786794237) 11 6 1 55 33
30376 94524 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3322 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 774668 5988381 2111924 37.7782700631784 -122.483776297443 (37.7782700631784, -122.483776297443) 11 6 2 55 26
36005 111369 Undocumented 4 Ficus nitida :: Laurel Fig 53 724 IRVING ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993485 2106687 37.7641864431876 -122.465739233402 (37.7641864431876, -122.465739233402) 11 8 11 56 12
38373 52226 Permitted Site 7 Ficus nitida :: Laurel Fig 53 423 Locust St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2005 12:00:00 AM     Permit Number 48405 5997634.34727934 2115023.86499621 37.7873157808513 -122.451989424725 (37.7873157808513, -122.451989424725) 11 6 1 54 31
38950 93145 Undocumented 4 Ficus nitida :: Laurel Fig 53 1152 Clement St 3 Sidewalk: Curb side : Cutout Tree Private 2           5991985 2113459 37.7826938870859 -122.471420727494 (37.7826938870859, -122.471420727494) 11 6 2 54 11
42506 121635 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 506 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2017 12:00:00 AM 3 3x3   5992560 2111978 37.7786607112968 -122.469323657797 (37.7786607112968, -122.469323657797) 11 6 2 54 11
49890 52592 Permitted Site 7 Ficus nitida :: Laurel Fig 53 327CALIFORNIA 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 48686 5988048.64326864 2113784.56845539 37.7833593060301 -122.48506257055 (37.7833593060301, -122.48506257055) 11 6 2 55 26
61629 117600 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 565 39TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5983700 2111975 37.7781364952795 -122.499973114435 (37.7781364952795, -122.499973114435) 11 6 2 55 26
62457 96407 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2           5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
78948 9076 Permitted Site 7 Ficus nitida :: Laurel Fig 53 5618 Geary Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5989554.31102 2112758.21214 37.7806288074212 -122.479778486374 (37.7806288074212, -122.479778486374) 11 6 2 55 26
79156 105290 Undocumented 4 Ficus nitida :: Laurel Fig 53 330 11TH AVE   Sidewalk: Curb side : Cutout Tree Private 2     15 4x4   5992515.1 2113228.4 37.7820913739714 -122.469570031425 (37.7820913739714, -122.469570031425) 11 6 2 54 11
80144 96411 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2012 12:00:00 AM     Permit Number 768662 5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
85440 96410 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767718 5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
87883 120156 Significant Tree 6 Ficus nitida :: Laurel Fig 53 758 10th Ave 1 Sidewalk: Curb side : Cutout Landscaping Private 2     10     5992930 2110298 37.7740692588728 -122.467921468059 (37.7740692588728, -122.467921468059) 11 6 2 54 11
90878 106915 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3832 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 772728 5995876.04542 2115884.62189 37.7895783172049 -122.458135060161 (37.7895783172049, -122.458135060161) 11 6 1 54 31
94512 9071 Permitted Site 7 Ficus nitida :: Laurel Fig 53 5600 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   03/01/1990 12:00:00 AM 12 3X3   5989606.68558 2112715.06065 37.7805133679778 -122.479594141591 (37.7805133679778, -122.479594141591) 11 6 2 55 26
97854 117647 Undocumented 4 Ficus nitida :: Laurel Fig 53 86 ROSSI AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   5996396 2111643 37.7779618147655 -122.456029304513 (37.7779618147655, -122.456029304513) 11 6 2 54 16
105276 9077 Permitted Site 7 Ficus nitida :: Laurel Fig 53 5618 Geary Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5989554.31102 2112758.21214 37.7806288074212 -122.479778486374 (37.7806288074212, -122.479778486374) 11 6 2 55 26
105841 93144 Undocumented 4 Ficus nitida :: Laurel Fig 53 1152 Clement St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/13/2016 12:00:00 AM 3     5991985 2113459 37.7826938870859 -122.471420727494 (37.7826938870859, -122.471420727494) 11 6 2 54 11
105995 96408 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2           5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
116714 59226 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 530 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3   Permit Number 779363 5992552.44717 2111818.61025 37.7782226338783 -122.469338181035 (37.7782226338783, -122.469338181035) 11 6 2 54 11
119477 106916 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3832 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2015 12:00:00 AM 3     5995876.04542 2115884.62189 37.7895783172049 -122.458135060161 (37.7895783172049, -122.458135060161) 11 6 1 54 31
124630 54736 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1247 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/1993 12:00:00 AM 12 5x5 Permit Number 31998 5994208.55249488 2107032.01090972 37.7651754625969 -122.463261729084 (37.7651754625969, -122.463261729084) 11 5 11 56 12
127826 117648 Undocumented 4 Ficus nitida :: Laurel Fig 53 86 ROSSI AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   5996396 2111643 37.7779618147655 -122.456029304513 (37.7779618147655, -122.456029304513) 11 6 2 54 16
129746 117649 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 82 ROSSI AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   5996392 2111672 37.778041211542 -122.456045238979 (37.778041211542, -122.456045238979) 11 6 2 54 16
140268 54410 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1248 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/1972 12:00:00 AM     Permit Number 10182 5993332.64911234 2106987.54521442 37.765002872173 -122.46628801063 (37.765002872173, -122.46628801063) 11 8 11 56 12
144627 9079 Permitted Site 7 Ficus nitida :: Laurel Fig 53 5625 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   5989525.4329 2112589.82108 37.7801647748824 -122.479866062567 (37.7801647748824, -122.479866062567) 11 6 2 55 26
149202 93146 Undocumented 4 Ficus nitida :: Laurel Fig 53 1152 Clement St 4 Sidewalk: Curb side : Cutout Tree Private 2           5991985 2113459 37.7826938870859 -122.471420727494 (37.7826938870859, -122.471420727494) 11 6 2 54 11
169641 12630 Permitted Site 7 Ficus nitida :: Laurel Fig 53 841 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2     40 3X3   5992831.38337 2114795.44702 37.7864123300728 -122.468589897945 (37.7864123300728, -122.468589897945) 11 6 2 54 11
170119 103480 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1247 06th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 5x5 Permit Number 31998 5994182.5 2107061.8 37.765255754741 -122.463353999562 (37.765255754741, -122.463353999562) 11 5 11 56 12
171777 96409 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 4 Sidewalk: Curb side : Cutout Tree Private 2           5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
177091 108561 Undocumented 4 Ficus nitida :: Laurel Fig 53 141 02nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995170 2114629.2 37.7860906748156 -122.460486880145 (37.7860906748156, -122.460486880145) 11 6 1 54 11
182236 117650 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 79 ROSSI AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     22 3x3   5996337 2111626 37.7779117506286 -122.456232175702 (37.7779117506286, -122.456232175702) 11 6 2 54 16
193266 97278 Permitted Site 7 Ficus nitida :: Laurel Fig 53 60 Palm Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 768156 5995934.7 2114107.9 37.7847032866401 -122.457803503646 (37.7847032866401, -122.457803503646) 11 6 1 54 31
3993 49288 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 19 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
32399 102602 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
40083 49240 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 24 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
40156 49286 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 14 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
45439 49260 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
45931 49235 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 8 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
46738 113373 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 HOWARD ST 4 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2015 12:00:00 AM   3x3   6014757 2116474 37.7922633974731 -122.39284966575 (37.7922633974731, -122.39284966575) 12 2 9 28855 6
60857 49274 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 20 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
69985 49269 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
81758 49264 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
84141 102599 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
85954 15110 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 6 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014281.21891 2116519.09631 37.7923607834286 -122.394499049528 (37.7923607834286, -122.394499049528) 12 2 9 28855 6
91238 49276 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 16 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
95381 49285 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 13 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
95982 49266 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 7 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
98499 102601 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
100078 102598 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
103493 49277 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 15 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
111958 15109 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014295.34515 2116528.26215 37.7923867359811 -122.3944508141 (37.7923867359811, -122.3944508141) 12 2 9 28855 6
114688 49239 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 10 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6

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)
);