155 rows where qSpecies_id = 68 sorted by Latitude

View and edit SQL

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)
2397 19696 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY9 -3 Sidewalk: Curb side : Cutout Tree DPW 1     12 15ST                      
3996 19960 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY41 18 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
6955 19957 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY40 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 15ST                      
9951 40088 Permitted Site 7 Prunus spp :: Cherry 68   1 Sidewalk: Curb side : Cutout Tree Private 2   03/09/1999 12:00:00 AM     Permit Number 41311                    
14491 19697 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY9 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 15ST                      
15283 19958 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY40 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 15ST                      
17361 19956 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY40 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 15ST                      
65616 86757 Permitted Site 7 Prunus spp :: Cherry 68 500 Brotherhood Way   unknown : Yard Tree Private 2         Permit Number 49739 5992573.4 2087955 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031) 9 8 6 64 24
25692 53523 Permitted Site 7 Prunus spp :: Cherry 68 221 Farallones St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2015 12:00:00 AM 4 3x3 Permit Number 775251 5994812.01878897 2088373.36040249 37.7139781801866 -122.459822827247 (37.7139781801866, -122.459822827247) 9 8 6 28861 24
26135 41411 Permitted Site 7 Prunus spp :: Cherry 68 531 Leland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/17/2000 12:00:00 AM     Permit Number 42023 6007932.96070428 2088253.06472002 37.7143937182098 -122.414463253601 (37.7143937182098, -122.414463253601) 9 7 8 309 39
151548 179164 DPW Maintained 1 Prunus spp :: Cherry 68 906 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6001361.98728 2088931.83355 37.7158861309088 -122.43722367146 (37.7158861309088, -122.43722367146) 9 7 6 28861 5
1082 261856 DPW Maintained 1 Prunus spp :: Cherry 68 937x Meade Ave 4 Front Yard : Yard Tree DPW 1       3x3   6012763 2089349 37.7176730984513 -122.397845439416 (37.7176730984513, -122.397845439416) 10 3 8 58 1
172665 179165 DPW Maintained 1 Prunus spp :: Cherry 68 671 London St 1 Sidewalk: Curb side : Yard Tree Private 2     3     6001067.99101 2089902.67343 37.7185351226768 -122.438309369006 (37.7185351226768, -122.438309369006) 9 7 6 28861 5
43718 45454 Permitted Site 7 Prunus spp :: Cherry 68 219 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2001 12:00:00 AM     Permit Number 44239 5994709.07342911 2090056.25354598 37.7185930847656 -122.460300500781 (37.7185930847656, -122.460300500781) 9 8 6 28861 24
142169 82056 Permitted Site 7 Prunus spp :: Cherry 68 447 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/11/2011 12:00:00 AM   3x3 Permit Number 767285 5993745.17939928 2090171.13367763 37.7188530246919 -122.463640596127 (37.7188530246919, -122.463640596127) 9 8 6 64 24
173631 96998 Significant Tree 6 Prunus spp :: Cherry 68 2451X Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
139368 50308 Permitted Site 7 Prunus spp :: Cherry 68 701 (REVISED) Grafton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/30/2003 12:00:00 AM     Permit Number 47019 5994734.51143453 2090549.74162157 37.7199495485694 -122.460248307265 (37.7199495485694, -122.460248307265) 9 8 6 28861 24
55073 213701 DPW Maintained 1 Prunus spp :: Cherry 68 700 Junipero Serra Blvd 130 : Tree Private 2     8 Width 0ft   5991210.94255 2091714.66662 37.7229448341183 -122.472512833822 (37.7229448341183, -122.472512833822) 9 8 4 64 40
127650 43350 DPW Maintained 1 Prunus spp :: Cherry 68 651 Cambridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2000 12:00:00 AM 8   Permit Number 43102 6007249.15746 2091540.31674 37.7233813767346 -122.417059535679 (37.7233813767346, -122.417059535679) 9 3 7 309 28
6901 80867 DPW Maintained 1 Prunus spp :: Cherry 68 123 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2008 12:00:00 AM 1 3x3 Permit Number 50655 6003213.7924 2092811.2834 37.7266433347113 -122.431099707385 (37.7266433347113, -122.431099707385) 9 7 6 28861 5
92263 196371 DPW Maintained 1 Prunus spp :: Cherry 68 1797 Bancroft Ave 3 Sidewalk: Curb side : Pot Tree Private 2     3 Width 1ft   6013429.50102 2092789.94242 37.7271583305791 -122.395782600389 (37.7271583305791, -122.395782600389) 10 3 8 58 1
65912 196067 DPW Maintained 1 Prunus spp :: Cherry 68 2338 Lane St 2 Front Yard : Yard Tree Private 2     2 Width 5ft   6013920.54146 2092873.26714 37.7274144278184 -122.394090896496 (37.7274144278184, -122.394090896496) 10 3 8 58 1
191781 196068 DPW Maintained 1 Prunus spp :: Cherry 68 1700 Armstrong Ave 9 Side Yard : Yard Tree Private 2     3     6013885.20395 2092887.61216 37.7274518522042 -122.394214063144 (37.7274518522042, -122.394214063144) 10 3 8 58 1
76705 196372 DPW Maintained 1 Prunus spp :: Cherry 68 1700 Armstrong Ave 7 Side Yard : Yard Tree Private 2     1     6013890.96771 2092887.97335 37.7274531643304 -122.394194162931 (37.7274531643304, -122.394194162931) 10 3 8 58 1
164522 199890 DPW Maintained 1 Prunus spp :: Cherry 68 1200x Quesada Ave 1 Median : Cutout Tree DPW 1     3 Width 0ft   6017354.2822 2093058.6837 37.7281137963921 -122.382233221943 (37.7281137963921, -122.382233221943) 10 3 8 58 1
128650 179166 DPW Maintained 1 Prunus spp :: Cherry 68 137 University St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007974.04708 2093261.84981 37.7281490902886 -122.414675489606 (37.7281490902886, -122.414675489606) 9 3 7 309 28
41546 213705 DPW Maintained 1 Prunus spp :: Cherry 68 175 Staples Ave 2 Sidewalk: Property side : Yard Tree Private 2     2     5998918.04752 2093764.63915 37.7290166671659 -122.4460184358 (37.7290166671659, -122.4460184358) 9 7 4 28861 40
191512 40428 Permitted Site 7 Prunus spp :: Cherry 68 29 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/1999 12:00:00 AM     Permit Number 41523 6007969.10251409 2094049.49213596 37.7303115087504 -122.414748301777 (37.7303115087504, -122.414748301777) 9 3 7 309 28
58869 105378 Undocumented 4 Prunus spp :: Cherry 68 298X SAN FERNANDO WAY 2 Sidewalk: Curb side : Cutout Tree Private 2     7 2x2   5991951 2094979 37.7319506911602 -122.470192222389 (37.7319506911602, -122.470192222389) 9 8 4 59 40
88482 56560 Permitted Site 7 Prunus spp :: Cherry 68 298X SAN FERNANDO WAY 1 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   5992129 2095185 37.7325266047982 -122.469591834842 (37.7325266047982, -122.469591834842) 9 8 4 59 40
154500 213704 DPW Maintained 1 Prunus spp :: Cherry 68 635 Mangels Ave 1 Sidewalk: Property side : Yard Tree Private 2     15     5997206.92035 2095245.84356 37.7329858403205 -122.452040726125 (37.7329858403205, -122.452040726125) 9 7 4 59 40
12108 213702 DPW Maintained 1 Prunus spp :: Cherry 68 714 Detroit St 6 Side Yard : Yard Tree Private 2     2     5999450.30082 2095402.17977 37.7335433498509 -122.444296031758 (37.7335433498509, -122.444296031758) 9 7 4 63 40
42662 213703 DPW Maintained 1 Prunus spp :: Cherry 68 27 Melrose Ave 2 Sidewalk: Property side : Yard Tree Private 2     16 Width 10ft   5999907.55727 2095471.26814 37.7337591277724 -122.442720129024 (37.7337591277724, -122.442720129024) 9 7 4 63 40
62171 238535 DPW Maintained 1 Prunus spp :: Cherry 68 118 Saint Marys Ave 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   6003941.15849 2095961.17353 37.7353334161892 -122.428809685439 (37.7353334161892, -122.428809685439) 2 7 5 63 7
55945 234919 DPW Maintained 1 Prunus spp :: Cherry 68 200 Saint Marys Ave 5 Side Yard : Yard Tree Private 2     2 Width 4ft   6003932.02563 2095971.19882 37.7353604264491 -122.428841975603 (37.7353604264491, -122.428841975603) 2 7 5 63 7
190581 234912 DPW Maintained 1 Prunus spp :: Cherry 68 266 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6006193.38743 2096072.09961 37.7357652112859 -122.421030756557 (37.7357652112859, -122.421030756557) 2 7 7 28859 2
82413 29657 DPW Maintained 1 Prunus spp :: Cherry 68 299X Cashmere St 1 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 3x3   6016930.34883 2095863.99444 37.7357931999838 -122.383894041377 (37.7357931999838, -122.383894041377) 10 3 8 58 1
25405 185047 DPW Maintained 1 Prunus spp :: Cherry 68 2767 34th Ave 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5985832.2143 2096586.5348 37.7360089113847 -122.491464150215 (37.7360089113847, -122.491464150215) 1 8 3 29491 35
185049 185048 DPW Maintained 1 Prunus spp :: Cherry 68 2767 34th Ave 3 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985831.6836 2096605.638 37.7360613326903 -122.491467390698 (37.7360613326903, -122.491467390698) 1 8 3 29491 35
40074 238536 DPW Maintained 1 Prunus spp :: Cherry 68 1 Penny Ln 4 Back Yard : Yard Tree Private 2     3 Width 2ft   6002355.47862 2096490.80035 37.736697774076 -122.434329814067 (37.736697774076, -122.434329814067) 2 7 5 63 7
57739 247592 DPW Maintained 1 Prunus spp :: Cherry 68 800 Tompkins Ave 13 Front Yard : Yard Tree Private 2     20     6008994.80779 2096446.35961 37.7369503684581 -122.411371547678 (37.7369503684581, -122.411371547678) 10 7 7 28859 2
208 107457 Undocumented 4 Prunus spp :: Cherry 68 2682 16TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2           5991487.4 2097177.7 37.7379609526954 -122.471955163509 (37.7379609526954, -122.471955163509) 1 8 4 29491 40
138611 237972 DPW Maintained 1 Prunus spp :: Cherry 68 400 Prospect Ave 14 Sidewalk: Property side : Yard Tree Private 2     11     6006214.1673 2097605.70169 37.7399773120135 -122.421067769962 (37.7399773120135, -122.421067769962) 2 7 7 28859 2
159933 183196 Undocumented 4 Prunus spp :: Cherry 68 2479 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5983931.1246 2098292.1691 37.740580843976 -122.498162805629 (37.740580843976, -122.498162805629) 1 8 3 29491 35
163327 181930 DPW Maintained 1 Prunus spp :: Cherry 68 2431 33rd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 0ft   5986090.3717 2098682.4704 37.7417788753673 -122.49072577603 (37.7417788753673, -122.49072577603) 1 8 3 29491 35
167001 11193 DPW Maintained 1 Prunus spp :: Cherry 68 162 Idora Ave 1 Median : Cutout Tree DPW 1     18 8   5995521.0890831 2099407.054304 37.7443147925186 -122.458170108957 (37.7443147925186, -122.458170108957) 1 8 4 59 40
13644 212860 DPW Maintained 1 Prunus spp :: Cherry 68 129 Merced Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5994548.15716 2099444.62817 37.7443620078908 -122.461537000359 (37.7443620078908, -122.461537000359) 1 8 4 59 40
22746 212861 DPW Maintained 1 Prunus spp :: Cherry 68 175 Garcia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5994619.09353 2099469.67136 37.7444348530002 -122.461293534079 (37.7444348530002, -122.461293534079) 1 8 4 59 40
85722 237945 DPW Maintained 1 Prunus spp :: Cherry 68 99 Aztec St 2 Side Yard : Yard Tree Private 2     14     6007968.29609 2099608.22097 37.7455745134701 -122.415144412305 (37.7455745134701, -122.415144412305) 2 7 7 28859 2
7636 21084 DPW Maintained 1 Prunus spp :: Cherry 68 2192X Sunset Blvd 20 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984923.321673 2100279.0596028 37.7460944336033 -122.494878681905 (37.7460944336033, -122.494878681905) 1 8 3 29491 35
4637 247987 DPW Maintained 1 Prunus spp :: Cherry 68 124 Mullen Ave 1 Front Yard : Yard Tree Private 2     11     6009857.2555 2099808.73815 37.7462310644209 -122.408626794296 (37.7462310644209, -122.408626794296) 2 7 7 28859 2
38671 234924 DPW Maintained 1 Prunus spp :: Cherry 68 323 Mullen Ave 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 5ft   6010626.29866 2099830.99271 37.7463352122137 -122.4059690917 (37.7463352122137, -122.4059690917) 2 7 7 28859 2
58423 234923 DPW Maintained 1 Prunus spp :: Cherry 68 24 Franconia St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6009961.80336 2099942.52208 37.7466042605945 -122.40827471332 (37.7466042605945, -122.40827471332) 2 7 7 28859 2
166835 196065 DPW Maintained 1 Prunus spp :: Cherry 68 602 Arthur Ave 28 Front Yard : Yard Tree Private 2     3     6015745.27894 2099859.59173 37.7466987082831 -122.388270101098 (37.7466987082831, -122.388270101098)   3 8 58 1
191979 196066 DPW Maintained 1 Prunus spp :: Cherry 68 602 Arthur Ave 29 Front Yard : Yard Tree Private 2     3     6015729.65904 2099863.28866 37.7467079937826 -122.38832437159 (37.7467079937826, -122.38832437159)   3 8 58 1
154760 4161 DPW Maintained 1 Prunus spp :: Cherry 68 3747 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/26/2001 12:00:00 AM 3 3X3   6005530.36537 2100484.52073 37.7478433240046 -122.423636704969 (37.7478433240046, -122.423636704969) 2 4 5 28859 22
80855 237971 DPW Maintained 1 Prunus spp :: Cherry 68 3178 Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6008600.41483 2100617.45628 37.7483811527764 -122.413029982045 (37.7483811527764, -122.413029982045) 2 4 7 28859 19
73071 196064 DPW Maintained 1 Prunus spp :: Cherry 68 1800 Illinois St 10 Sidewalk: Curb side : Yard Tree Private 2     2 Width 5ft   6016257.27394 2100629.71457 37.7488416623195 -122.386553348372 (37.7488416623195, -122.386553348372) 10 3 8 58 1
41171 40117 Permitted Site 7 Prunus spp :: Cherry 68 51 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/29/2001 12:00:00 AM     Permit Number 41332 6004835.9770779 2101026.68937802 37.7492927732201 -122.42607645855 (37.7492927732201, -122.42607645855) 2 4 5 28862 22
70311 50019 Permitted Site 7 Prunus spp :: Cherry 68 1363 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46753 6009308.17778689 2101227.80950502 37.7500967527825 -122.410625639874 (37.7500967527825, -122.410625639874) 2 4 7 28859 19
193280 196534 DPW Maintained 1 Prunus spp :: Cherry 68 2221 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6011830.1521 2101342.38489 37.7505524246675 -122.401912510764 (37.7505524246675, -122.401912510764) 10 3 8 28856 1
79051 237948 DPW Maintained 1 Prunus spp :: Cherry 68 3387 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6007155.62665 2101453.96351 37.7505968017181 -122.418085332981 (37.7505968017181, -122.418085332981) 2 4 7 28859 19
45518 238533 DPW Maintained 1 Prunus spp :: Cherry 68 2929 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6009029.88036 2101415.6654 37.7505969563892 -122.411601283067 (37.7505969563892, -122.411601283067) 2 4 7 28859 19
125827 56999 Permitted Site 7 Prunus spp :: Cherry 68 4206 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1974 12:00:00 AM     Permit Number 14257 6001838.61131344 2101787.92307498 37.7512130767933 -122.436495868054 (37.7512130767933, -122.436495868054) 2 4 5 28862 22
129139 196536 DPW Maintained 1 Prunus spp :: Cherry 68 1422 Rhode Island St 1 : Tree Private 2     10 Width 3ft   6011983.19537 2101729.68858 37.7516244165498 -122.401410487604 (37.7516244165498, -122.401410487604) 10 3 8 28856 29
106492 20856 DPW Maintained 1 Prunus spp :: Cherry 68 1892X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984852.8466778 2102317.5089788 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334) 1 8 3 56 35
153560 20857 DPW Maintained 1 Prunus spp :: Cherry 68 1892X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984852.8466778 2102317.5089788 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334) 1 8 3 56 35
191467 20855 DPW Maintained 1 Prunus spp :: Cherry 68 1892X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984852.8466778 2102317.5089788 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334) 1 8 3 56 35
83211 93959 Permitted Site 7 Prunus spp :: Cherry 68 419 Elizabeth St   Front Yard : Cutout Tree Private 2       3x3 Permit Number 53399 6003681 2102149 37.7523090296265 -122.430150445418 (37.7523090296265, -122.430150445418) 2 4 5 28862 22
115685 234917 DPW Maintained 1 Prunus spp :: Cherry 68 1341 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6011175.62775 2102086.99041 37.7525603976539 -122.404228319896 (37.7525603976539, -122.404228319896) 10 4 8 28859 19
151735 102286 Undocumented 4 Prunus spp :: Cherry 68 122 Hoffman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2014 12:00:00 AM 26 4x4 Permit Number 772865 6000574.8 2102350.7 37.7526864299915 -122.440906621345 (37.7526864299915, -122.440906621345) 2 4 5 28862 22
189473 121317 DPW Maintained 1 Prunus spp :: Cherry 68 1270 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 3x3   6007670 2102262 37.7528444245459 -122.416363810551 (37.7528444245459, -122.416363810551) 2 4 7 28859 19
186812 234918 DPW Maintained 1 Prunus spp :: Cherry 68 1319 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011166.83162 2102201.8831 37.7528753762183 -122.404266824377 (37.7528753762183, -122.404266824377) 10 4 8 28859 19
23889 212859 DPW Maintained 1 Prunus spp :: Cherry 68 1850 17th Ave 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   5990965.56748 2102825.03354 37.7534368589362 -122.474171325764 (37.7534368589362, -122.474171325764) 1 8 4 56 12
100657 237946 DPW Maintained 1 Prunus spp :: Cherry 68 923 Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008002.82503 2102600.12508 37.7537915497511 -122.415236769973 (37.7537915497511, -122.415236769973) 2 4 7 28859 19
181735 237947 DPW Maintained 1 Prunus spp :: Cherry 68 923 Shotwell St 5 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6008000.76687 2102633.77568 37.7538838309939 -122.415246269499 (37.7538838309939, -122.415246269499) 2 4 7 28859 19
53658 237949 DPW Maintained 1 Prunus spp :: Cherry 68 3145 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008037.75868 2102668.77987 37.7539820234627 -122.415120820376 (37.7539820234627, -122.415120820376) 2 4 7 28859 19
70091 237950 DPW Maintained 1 Prunus spp :: Cherry 68 3145 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008062.3853 2102670.45818 37.7539880156382 -122.415035774193 (37.7539880156382, -122.415035774193) 2 4 7 28859 19
177866 53304 Permitted Site 7 Prunus spp :: Cherry 68 47 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/1969 12:00:00 AM 2 4x4 Permit Number 6194 6004117.25840717 2102785.08371789 37.7540802654829 -122.42868713344 (37.7540802654829, -122.42868713344) 2 4 5 28862 22
50445 104765 Undocumented 4 Prunus spp :: Cherry 68 47 VICKSBURG ST 2 Sidewalk: Curb side : Cutout Tree Private 2     2 4x4   6004132.1 2102787.4 37.7540874654016 -122.428635972714 (37.7540874654016, -122.428635972714) 2 4 5 28862 22
121838 53181 Permitted Site 7 Prunus spp :: Cherry 68 2784 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/07/2006 12:00:00 AM   3x3 Permit Number 49099 6010077.71172244 2102830.43618978 37.7545403242811 -122.408077545352 (37.7545403242811, -122.408077545352) 2 4 7 28859 19
28549 16688 DPW Maintained 1 Prunus spp :: Cherry 68 600X Noriega St 1 Median : Cutout Tree DPW 1     3 2   5992180.8132004 2103552.59538 37.7555048781502 -122.470021758383 (37.7555048781502, -122.470021758383) 1 8 4 56 12
75245 234921 DPW Maintained 1 Prunus spp :: Cherry 68 1062 Valencia St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6006317.5902 2103335.47216 37.7557157877704 -122.421116917936 (37.7557157877704, -122.421116917936) 2 4 5 28859 19
99909 96676 Property Tree 8 Prunus spp :: Cherry 68 1701 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/22/2011 12:00:00 AM       5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698) 1 8 3 56 35
139351 96677 Permitted Site 7 Prunus spp :: Cherry 68 1701 21st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767971 5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698) 1 8 3 56 35
149775 196062 DPW Maintained 1 Prunus spp :: Cherry 68 1751 22nd St 8 Side Yard : Yard Tree Private 2     5 Width 5ft   6012859.76673 2103766.08005 37.7572647746544 -122.398522052264 (37.7572647746544, -122.398522052264) 10 3 8 28856 29
85690 196063 DPW Maintained 1 Prunus spp :: Cherry 68 1751 22nd St 9 Side Yard : Yard Tree Private 2     3 Width 5ft   6012868.1198 2103766.18767 37.757265535503 -122.398493171445 (37.757265535503, -122.398493171445) 10 3 8 28856 29
1810 253859 Planning Code 138.1 required 2 Prunus spp :: Cherry 68 130 Graystone Ter 1 Front Yard : Yard Tree Private 2       6x6 Permit Number 780749 5998952.88335 2104176.47413 37.7576070480405 -122.446646826709 (37.7576070480405, -122.446646826709) 2 5 5 28862 3
97628 234922 DPW Maintained 1 Prunus spp :: Cherry 68 818 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6010155.119 2104325.0374 37.758648498551 -122.407915239024 (37.758648498551, -122.407915239024) 2 4 7 28859 19
75737 50440 Permitted Site 7 Prunus spp :: Cherry 68 1539 Funston Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320979 (37.7593865436509, -122.47037320979) 1 8 4 56 12
174316 50441 Permitted Site 7 Prunus spp :: Cherry 68 1539 Funston Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320979 (37.7593865436509, -122.47037320979) 1 8 4 56 12
174947 50443 Permitted Site 7 Prunus spp :: Cherry 68 1539 Funston Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320979 (37.7593865436509, -122.47037320979) 1 8 4 56 12
193278 50442 Permitted Site 7 Prunus spp :: Cherry 68 1539 Funston Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320979 (37.7593865436509, -122.47037320979) 1 8 4 56 12
188790 93987 Permitted Site 7 Prunus spp :: Cherry 68 200 Belgrave Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 53411 5997460.5 2104904 37.759519290122 -122.451860552802 (37.759519290122, -122.451860552802) 15 5 11 29492 12
5476 196535 DPW Maintained 1 Prunus spp :: Cherry 68 2050 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6011971.89654 2104695.59738 37.7597675204772 -122.401658003519 (37.7597675204772, -122.401658003519) 10 3 8 28856 29
107251 238534 DPW Maintained 1 Prunus spp :: Cherry 68 671 Church St 39 Front Yard : Yard Tree Private 2     12 Width 3ft   6004315.93981 2105094.00544 37.7604312615151 -122.428164581928 (37.7604312615151, -122.428164581928) 2 4 5 28862 3
190691 196373 DPW Maintained 1 Prunus spp :: Cherry 68 1900 19th St 2 Front Yard : Yard Tree Private 2     1     6012066.64129 2105141.25616 37.760996487211 -122.401361645431 (37.760996487211, -122.401361645431) 10 3 8 28856 29
58981 196335 DPW Maintained 1 Prunus spp :: Cherry 68 1900 19th St 10 Front Yard : Yard Tree Private 2     1     6012008.47004 2105145.92381 37.761006057794 -122.401563163706 (37.761006057794, -122.401563163706) 10 3 8 28856 29
89476 49741 Permitted Site 7 Prunus spp :: Cherry 68 646@ 18th Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2003 12:00:00 AM     Permit Number 46540 6010086.91434322 2105281.03537103 37.7612696346383 -122.408218548113 (37.7612696346383, -122.408218548113) 2 4 8 28859 19
39858 84640 DPW Maintained 1 Prunus spp :: Cherry 68 1363 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/2009 12:00:00 AM 3 3x3 Permit Number 52752 5988634.2057 2106032.7782 37.7621091296561 -122.482468596885 (37.7621091296561, -122.482468596885) 1 8 3 56 35

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