trees
6,344 rows where qSpecies_id = 19 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10710 | 10015 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 232 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/2019 12:00:00 AM | 3 | 3x3 | 6005430.70254 | 2107623.59079 | 37.7674399129618 | -122.424489062615 | (37.7674399129618, -122.424489062615) | 8 | 4 | 5 | 28853 | 19 | ||
41837 | 100154 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 421 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768665 | 5995548.20979 | 2113421.38615 | 37.7827960924124 | -122.459090895565 | (37.7827960924124, -122.459090895565) | 11 | 6 | 2 | 54 | 11 | |
138493 | 100155 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 421 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768665 | 5995547.63901 | 2113410.08576 | 37.7827650317513 | -122.459092051698 | (37.7827650317513, -122.459092051698) | 11 | 6 | 2 | 54 | 11 | |
185437 | 100156 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 421 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768665 | 5995549.3318 | 2113386.41255 | 37.7827001287608 | -122.459084480701 | (37.7827001287608, -122.459084480701) | 11 | 6 | 2 | 54 | 11 | |
75465 | 100192 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 62 Nordhoff St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x6 | 6000448 | 2095531 | 37.7339539318334 | -122.440855946438 | (37.7339539318334, -122.440855946438) | 9 | 7 | 5 | 63 | 40 | ||||
193537 | 100208 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 634 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x10 | 5992873.67037 | 2111136.23263 | 37.7763675669424 | -122.468177309737 | (37.7763675669424, -122.468177309737) | 11 | 6 | 2 | 54 | 11 | |||
134278 | 100213 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 120 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768999 | 5994920.57635 | 2114719.03859 | 37.786322995296 | -122.461356328132 | (37.786322995296, -122.461356328132) | 11 | 6 | 1 | 54 | 11 | |
105054 | 100572 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 3020 Washington St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Permit Number 769157 | 6000180.60876 | 2116141.82829 | 37.790530933705 | -122.443260250183 | (37.790530933705, -122.443260250183) | 13 | 6 | 1 | 29490 | 27 | |||
171434 | 100574 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3020 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769157 | 6000163.3721 | 2116141.12767 | 37.790528027094 | -122.443319837452 | (37.790528027094, -122.443319837452) | 13 | 6 | 1 | 29490 | 27 | |
142532 | 100766 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 5 Bernice St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6008540.86441 | 2108549.92481 | 37.7701585563026 | -122.413796931097 | (37.7701585563026, -122.413796931097) | 8 | 2 | 9 | 28853 | 19 | |||
125972 | 100767 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 5 Bernice St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6008552.5451 | 2108569.89126 | 37.7702140354665 | -122.413757940076 | (37.7702140354665, -122.413757940076) | 8 | 2 | 9 | 28853 | 19 | |||
108444 | 100836 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 291 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2012 12:00:00 AM | Permit Number 769343 | 5986476 | 2114001.5 | 37.7838632073277 | -122.490519185954 | (37.7838632073277, -122.490519185954) | 11 | 6 | 1 | 55 | 33 | |||
64882 | 101080 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2619 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 2 | 3x3 | Permit Number 776708 | 5999607.59307 | 2117837.36801 | 37.7951537466998 | -122.445364806757 | (37.7951537466998, -122.445364806757) | 13 | 9 | 1 | 57 | 17 | |
127239 | 101297 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2111 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 0 | Permit Number 47337 | 6014367.177 | 2093395.6537 | 37.7288736101074 | -122.392583390474 | (37.7288736101074, -122.392583390474) | 10 | 3 | 8 | 58 | 1 | ||
116765 | 101314 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 4244X 19th St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10 | 4x4 | 6001912 | 2104709 | 37.7592378221466 | -122.436451128899 | (37.7592378221466, -122.436451128899) | 2 | 4 | 5 | 28862 | 3 | |||
39545 | 101317 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 273 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
101776 | 101376 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 120 Cherry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768069 | 5996140.40123 | 2115714.3394 | 37.7891259534341 | -122.457208099272 | (37.7891259534341, -122.457208099272) | 11 | 6 | 1 | 54 | 31 | |
51600 | 101418 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2998 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6000408.58761 | 2116174.99393 | 37.7906349951681 | -122.44247384162 | (37.7906349951681, -122.44247384162) | 13 | 6 | 1 | 29490 | 27 | |||
157811 | 101419 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2998 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6000395.57076 | 2116172.72347 | 37.7906280191169 | -122.442518715983 | (37.7906280191169, -122.442518715983) | 13 | 6 | 1 | 29490 | 27 | |||
46597 | 101425 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2200 Broderick St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2012 12:00:00 AM | 4 | Permit Number 769517 | 6000363.7356 | 2116257.44034 | 37.790858814824 | -122.442634948863 | (37.790858814824, -122.442634948863) | 13 | 6 | 1 | 29490 | 27 | ||
2609 | 10168 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1025 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 6005769.33975 | 2102766.2906 | 37.7541220254375 | -122.422972492697 | (37.7541220254375, -122.422972492697) | 2 | 4 | 5 | 28859 | 19 | |||
31712 | 10170 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1029 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005772.3490263 | 2102822.9576897 | 37.7542777899419 | -122.422966113164 | (37.7542777899419, -122.422966113164) | 2 | 4 | 5 | 28859 | 19 | |||
122727 | 10172 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1029 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 3 | 3X3 | 6005770.35285 | 2102739.95436 | 37.7540497693899 | -122.422967117444 | (37.7540497693899, -122.422967117444) | 2 | 4 | 5 | 28859 | 19 | ||
103306 | 101752 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2221 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2013 12:00:00 AM | 3 | 2x2 | Permit Number 769394 | 6001308.08999 | 2116217.76222 | 37.7908036558184 | -122.439364687429 | (37.7908036558184, -122.439364687429) | 13 | 6 | 1 | 29490 | 27 | |
121055 | 101785 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 770191 | 6012320 | 2112811 | 37.7820699977989 | -122.401024297599 | (37.7820699977989, -122.401024297599) | 6 | 2 | 9 | 28856 | 34 | ||
28745 | 101787 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012351.4106 | 2112819.1478 | 37.782094121907 | -122.400916203169 | (37.782094121907, -122.400916203169) | 6 | 2 | 9 | 28856 | 34 | |||
35279 | 101788 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012361.4847 | 2112829.2218 | 37.7821223447049 | -122.400882059134 | (37.7821223447049, -122.400882059134) | 6 | 2 | 9 | 28856 | 34 | |||
121066 | 101789 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012371.5587 | 2112837.9221 | 37.7821467956256 | -122.400847818878 | (37.7821467956256, -122.400847818878) | 6 | 2 | 9 | 28856 | 34 | |||
134223 | 101790 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012384.8381 | 2112849.8278 | 37.782180226609 | -122.400802714555 | (37.782180226609, -122.400802714555) | 6 | 2 | 9 | 28856 | 34 | |||
155049 | 101791 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012441.6191 | 2112904.7771 | 37.7823342715514 | -122.400610137868 | (37.7823342715514, -122.400610137868) | 6 | 2 | 9 | 28856 | 34 | |||
83432 | 101792 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012455.0203 | 2112918.9994 | 37.7823740700821 | -122.40056477473 | (37.7823740700821, -122.40056477473) | 6 | 2 | 9 | 28856 | 34 | |||
7714 | 101793 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012464.9097 | 2112928.8888 | 37.7824017756076 | -122.400531256447 | (37.7824017756076, -122.400531256447) | 6 | 2 | 9 | 28856 | 34 | |||
78065 | 101794 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012479.5462 | 2112942.7341 | 37.7824406078424 | -122.400481593112 | (37.7824406078424, -122.400481593112) | 6 | 2 | 9 | 28856 | 34 | |||
179222 | 101795 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 778116 | 6012494.1826 | 2112956.975 | 37.7824805262764 | -122.400431957866 | (37.7824805262764, -122.400431957866) | 6 | 2 | 9 | 28856 | 34 | ||
156038 | 101796 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012510.0058 | 2112970.4246 | 37.782518338144 | -122.40037816113 | (37.782518338144, -122.40037816113) | 6 | 2 | 9 | 28856 | 34 | |||
55293 | 101874 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 952 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2012 12:00:00 AM | Permit Number 769482 | 6009937 | 2103656 | 37.7567992582457 | -122.408622400801 | (37.7567992582457, -122.408622400801) | 2 | 4 | 7 | 28859 | 19 | |||
157359 | 101893 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 700 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011771.05994 | 2117771.43328 | 37.7956595371067 | -122.403272447586 | (37.7956595371067, -122.403272447586) | 3 | 1 | 10 | 28860 | 4 | |||
98792 | 102001 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 115X Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6001082.7 | 2105694.4 | 37.7618963312911 | -122.439389876376 | (37.7618963312911, -122.439389876376) | 15 | 5 | 5 | 28862 | 3 | |||
152619 | 102003 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 115X Douglass St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6001082.7 | 2105694.4 | 37.7618963312911 | -122.439389876376 | (37.7618963312911, -122.439389876376) | 15 | 5 | 5 | 28862 | 3 | |||
156603 | 102050 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2023 Palou Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/14/2013 12:00:00 AM | 1 | Permit Number 770150 | 6012608.45431 | 2096904.73371 | 37.738410985264 | -122.398909642062 | (37.738410985264, -122.398909642062) | 10 | 3 | 8 | 58 | 1 | ||
85416 | 102087 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 212 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2012 12:00:00 AM | 3x3 | Permit Number 769733 | 6006591.9 | 2098371.2 | 37.7421004853962 | -122.41981602805 | (37.7421004853962, -122.41981602805) | 2 | 7 | 7 | 28859 | 2 | |
78076 | 102125 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2013 12:00:00 AM | 11 | 3x3 | Permit Number 769555 | 6010481.2 | 2120003.6 | 37.8017163995107 | -122.407893097298 | (37.8017163995107, -122.407893097298) | 3 | 1 | 10 | 308 | 23 | |
26258 | 102205 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 101X Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6004493.1 | 2101013.4 | 37.7492368987377 | -122.427261188102 | (37.7492368987377, -122.427261188102) | 2 | 4 | 5 | 28862 | 22 | |||
118669 | 102206 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 101X Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6004493.1 | 2101013.4 | 37.7492368987377 | -122.427261188102 | (37.7492368987377, -122.427261188102) | 2 | 4 | 5 | 28862 | 22 | |||
128195 | 102449 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2205 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2014 12:00:00 AM | Permit Number 772662 | 6003508.7 | 2117188.3 | 37.7935934914571 | -122.431820013768 | (37.7935934914571, -122.431820013768) | 13 | 9 | 1 | 29490 | 27 | |||
75549 | 102459 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 705 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2014 12:00:00 AM | 12 | 3x3 | Permit Number 773618 | 6008558.7 | 2104414.6 | 37.758804910973 | -122.413442735016 | (37.758804910973, -122.413442735016) | 2 | 4 | 7 | 28859 | 19 | |
23862 | 102476 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 760 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
5958 | 102480 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1456 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768914 | 6004877.03101 | 2120232.91154 | 37.8020306879258 | -122.427302455863 | (37.8020306879258, -122.427302455863) | 13 | 9 | 1 | 57 | 17 | |
122479 | 102671 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 604 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2013 12:00:00 AM | 3x3 | Permit Number 768898 | 6001121.5 | 2110751.4 | 37.7757838038891 | -122.439618230267 | (37.7757838038891, -122.439618230267) | 15 | 5 | 11 | 29492 | 10 | ||
48938 | 102827 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 2001X Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997438 | 2109144 | 37.7711599615563 | -122.452244312179 | (37.7711599615563, -122.452244312179) | 15 | 5 | 11 | 29492 | 9 | ||||
56096 | 102870 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1329 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769960 | 6008907.65031 | 2117482.11639 | 37.7947048087356 | -122.413159922398 | (37.7947048087356, -122.413159922398) | 5 | 1 | 10 | 28857 | 21 | |
173408 | 103000 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2440 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x4 | Permit Number 19730 | 6002354.34125 | 2116771.69736 | 37.7923841036956 | -122.435784363176 | (37.7923841036956, -122.435784363176) | 13 | 9 | 1 | 29490 | 27 | ||
170842 | 103021 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 40X Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 3x3 | See 61 Fair Ave for old permit records | 6006901 | 2099544.2 | 37.7453386886112 | -122.418830426928 | (37.7453386886112, -122.418830426928) | 2 | 7 | 7 | 28859 | 2 | |
64909 | 103023 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 40X Coleridge St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6006901 | 2099544.2 | 37.7453386886112 | -122.418830426928 | (37.7453386886112, -122.418830426928) | 2 | 7 | 7 | 28859 | 2 | |||
96226 | 103029 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 434 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/09/2013 12:00:00 AM | Permit Number 767522 | 5993810.5 | 2090074.3 | 37.7185909063027 | -122.463407787149 | (37.7185909063027, -122.463407787149) | 9 | 8 | 6 | 64 | 24 | |||
175904 | 103037 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 500X Alvarado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4x4 | 6003108.4 | 2102730.8 | 37.7538740670297 | -122.432172131424 | (37.7538740670297, -122.432172131424) | 2 | 4 | 5 | 28862 | 22 | |||
183811 | 103098 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 680 DOUGLASS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770082 | 6001191 | 2102437 | 37.7529584646863 | -122.438781880632 | (37.7529584646863, -122.438781880632) | 2 | 4 | 5 | 28862 | 22 | |
10175 | 103130 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 418 28th Ave | 1 | : | Tree | Private 2 | 1 | 5987189.39247 | 2113118.19249 | 37.7814795396885 | -122.487986220863 | (37.7814795396885, -122.487986220863) | 11 | 6 | 2 | 55 | 26 | ||||
75657 | 10318 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 742 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/03/2013 12:00:00 AM | 3 | 3x4 | 6002583.1273 | 2109220.4265 | 37.771663211597 | -122.434452611108 | (37.771663211597, -122.434452611108) | 15 | 5 | 11 | 29492 | 9 | ||
12072 | 10326 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 819 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2007 12:00:00 AM | 3 | 3X3 | 6002207.57646 | 2109118.35989 | 37.7713616369503 | -122.43574435864 | (37.7713616369503, -122.43574435864) | 15 | 5 | 11 | 29492 | 9 | ||
69223 | 103263 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3589 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2013 12:00:00 AM | 4 | 3x3 | Permit Number 58653 | 5997688.71427 | 2115419.45678 | 37.7884050847717 | -122.451829876464 | (37.7884050847717, -122.451829876464) | 11 | 6 | 1 | 54 | 31 | |
167060 | 10327 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 820 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2006 12:00:00 AM | 6 | 4X4 | 6002215.6736 | 2109169.9481 | 37.7715037453317 | -122.435720041807 | (37.7715037453317, -122.435720041807) | 15 | 5 | 11 | 29492 | 9 | ||
105233 | 103282 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3195X Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | Permit Number 770064 | 5998987.7 | 2116257.6 | 37.790780717413 | -122.447395962042 | (37.790780717413, -122.447395962042) | 13 | 6 | 1 | 29490 | 31 | ||
77525 | 10330 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 827 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 3 | 6002167.0188 | 2109110.84492 | 37.7713386988586 | -122.435884111474 | (37.7713386988586, -122.435884111474) | 15 | 5 | 11 | 29492 | 9 | |||
158972 | 10332 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 839 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2009 12:00:00 AM | 3 | 3X3 | 6002120.64494 | 2109105.29533 | 37.7713208266255 | -122.436044123345 | (37.7713208266255, -122.436044123345) | 15 | 5 | 11 | 29492 | 9 | ||
131681 | 10338 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 888 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2007 12:00:00 AM | 3 | 4X4 | 6001920.2327 | 2109127.5485 | 37.771370540661 | -122.436738950305 | (37.771370540661, -122.436738950305) | 15 | 5 | 11 | 29492 | 9 | ||
167999 | 10341 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 926 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/25/2012 12:00:00 AM | 3 | 3X4 | 6001658.9788 | 2109094.1055 | 37.7712638636327 | -122.437640242684 | (37.7712638636327, -122.437640242684) | 15 | 5 | 11 | 29492 | 9 | ||
99380 | 103691 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 136 Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2013 12:00:00 AM | 2 | 2x4 | Permit Number 768685 | 6002704.42424 | 2119047.06433 | 37.7986515518927 | -122.434735850806 | (37.7986515518927, -122.434735850806) | 13 | 9 | 1 | 57 | 17 | |
49872 | 103693 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2827 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770206 | 5999366.97843 | 2118720.21068 | 37.7975640593007 | -122.44626090563 | (37.7975640593007, -122.44626090563) | 13 | 9 | 1 | 57 | 17 | |
70565 | 103783 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1233 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006792.9578 | 2115204.8755 | 37.7883331262118 | -122.420315348616 | (37.7883331262118, -122.420315348616) | 13 | 9 | 10 | 28858 | 21 | ||
18367 | 103786 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1221 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006804.9894 | 2115120.2532 | 37.7881014522033 | -122.420267712778 | (37.7881014522033, -122.420267712778) | 13 | 9 | 10 | 28858 | 21 | ||
24766 | 103795 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1215 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006811.4062 | 2115079.7468 | 37.7879905931823 | -122.420242635719 | (37.7879905931823, -122.420242635719) | 13 | 9 | 10 | 28858 | 21 | ||
133533 | 103816 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1100 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006901.46306 | 2114785.14538 | 37.7871867641959 | -122.41991014106 | (37.7871867641959, -122.41991014106) | 13 | 9 | 10 | 28858 | 21 | ||
168428 | 103823 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1000 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006948.13322 | 2114434.09135 | 37.7862254851663 | -122.419723753855 | (37.7862254851663, -122.419723753855) | 13 | 9 | 9 | 28858 | 36 | ||
125347 | 103824 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1000 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006951.91038 | 2114418.64606 | 37.7861832889612 | -122.419709589538 | (37.7861832889612, -122.419709589538) | 13 | 9 | 9 | 28858 | 36 | ||
28318 | 103825 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1000 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006956.54225 | 2114398.79268 | 37.7861290373663 | -122.41969215528 | (37.7861290373663, -122.41969215528) | 13 | 9 | 9 | 28858 | 36 | ||
176274 | 103829 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 999 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006929.69351 | 2114192.11644 | 37.7855600426056 | -122.41977037472 | (37.7855600426056, -122.41977037472) | 13 | 9 | 9 | 28858 | 36 | ||
72986 | 103830 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 999 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006932.57902 | 2114171.45975 | 37.7855034869436 | -122.419758925448 | (37.7855034869436, -122.419758925448) | 13 | 9 | 9 | 28858 | 36 | ||
176866 | 103873 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1331 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006745.9342 | 2115531.8344 | 37.7892282247503 | -122.42050126059 | (37.7892282247503, -122.42050126059) | 13 | 9 | 10 | 28858 | 21 | ||
141650 | 103914 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1300X Fitzgerald Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
136631 | 103916 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1300X Fitzgerald Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
21758 | 103918 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1300X Fitzgerald Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
121233 | 103920 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1300X Fitzgerald Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
119550 | 103922 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1300X Fitzgerald Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
163705 | 103933 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 137 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2013 12:00:00 AM | 3x6 | Permit Number 770240 | 5995169.2 | 2114653 | 37.786155977168 | -122.460491373107 | (37.786155977168, -122.460491373107) | 11 | 6 | 1 | 54 | 11 | ||
124456 | 103954 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2135 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2013 12:00:00 AM | 4 | Permit Number 770408 | 6002682.72331 | 2119183.26919 | 37.7990243028993 | -122.434820688326 | (37.7990243028993, -122.434820688326) | 13 | 9 | 1 | 57 | 17 | ||
135666 | 103957 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2465 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770692 | 6002902.62076 | 2116470.86647 | 37.7915892279996 | -122.433865791789 | (37.7915892279996, -122.433865791789) | 13 | 9 | 1 | 29490 | 27 | |
135541 | 103962 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3240 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | Permit Number 780028 | 5998623.05948 | 2116578.56663 | 37.7916411629484 | -122.448680722253 | (37.7916411629484, -122.448680722253) | 11 | 6 | 1 | 54 | 30 | ||
67674 | 104084 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3400 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2013 12:00:00 AM | 2 | Permit Number 770438 | 5998506.79401 | 2115581.38859 | 37.7888965273999 | -122.44901113317 | (37.7888965273999, -122.44901113317) | 13 | 6 | 1 | 54 | 31 | ||
142573 | 104137 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 342 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 5x12 | 5989676.63193 | 2113037.32842 | 37.7814022881745 | -122.479375750311 | (37.7814022881745, -122.479375750311) | 11 | 6 | 2 | 55 | 26 | |||
75682 | 104217 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2730 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2015 12:00:00 AM | 2 | 3x3 | Permit Number 770301 | 6001616.70507 | 2117829.24161 | 37.7952459173057 | -122.438412399836 | (37.7952459173057, -122.438412399836) | 13 | 9 | 1 | 57 | 27 | |
51143 | 104236 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1265 Bosworth St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770727 | 6000365.2 | 2096127.5 | 37.7355870653858 | -122.441184993439 | (37.7355870653858, -122.441184993439) | 9 | 7 | 4 | 63 | 40 | ||||
171080 | 104237 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1265 Bosworth St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 770727 | 6000365.2 | 2096127.5 | 37.7355870653858 | -122.441184993439 | (37.7355870653858, -122.441184993439) | 9 | 7 | 4 | 63 | 40 | ||||
148050 | 104242 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 42 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998257.6 | 2108324 | 37.7689553686247 | -122.449350208019 | (37.7689553686247, -122.449350208019) | 15 | 5 | 11 | 29492 | 9 | ||||
25601 | 104243 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 42 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998257.6 | 2108324 | 37.7689553686247 | -122.449350208019 | (37.7689553686247, -122.449350208019) | 15 | 5 | 11 | 29492 | 9 | ||||
129475 | 104244 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 42 Belvedere St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2013 12:00:00 AM | 3x3 | Permit Number 769673 | 5998257.6 | 2108324 | 37.7689553686247 | -122.449350208019 | (37.7689553686247, -122.449350208019) | 15 | 5 | 11 | 29492 | 9 | ||
39495 | 104245 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 42 Belvedere St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2013 12:00:00 AM | 3x3 | Permit Number 769673 | 5998257.6 | 2108324 | 37.7689553686247 | -122.449350208019 | (37.7689553686247, -122.449350208019) | 15 | 5 | 11 | 29492 | 9 | ||
121285 | 104318 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 22 Beaver St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6002763 | 2106816 | 37.765071454108 | -122.433658549479 | (37.765071454108, -122.433658549479) | 15 | 5 | 5 | 28862 | 3 | ||||
38434 | 104322 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 90X Beaver St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002383 | 2106795 | 37.7649922243231 | -122.434971372236 | (37.7649922243231, -122.434971372236) | 15 | 5 | 5 | 28862 | 3 | ||||
82302 | 104323 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 90X Beaver St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6002383 | 2106795 | 37.7649922243231 | -122.434971372236 | (37.7649922243231, -122.434971372236) | 15 | 5 | 5 | 28862 | 3 |
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) );