trees
979 rows where qSpecies_id = 13 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
51580 | 109211 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 819 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773413 | 6011187.72328 | 2090968.52831 | 37.722032138266 | -122.403404362845 | (37.722032138266, -122.403404362845) | 10 | 3 | 7 | 309 | 28 | |
80700 | 253542 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 10 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 02:42:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
95991 | 253541 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 9 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 03:59:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
106265 | 253543 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 11 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 02:35:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
118918 | 253544 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 12 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 02:38:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
163713 | 253540 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 8 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 04:11:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
116185 | 52791 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 955@ MOSCOW Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 1 | Permit Number 48832 | 6004754.52241 | 2091271.39974 | 37.7225023397811 | -122.425663900979 | (37.7225023397811, -122.425663900979) | 9 | 7 | 6 | 28861 | 5 | ||
13984 | 115980 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011593.71434 | 2091235.60939 | 37.7227881560287 | -122.402019710862 | (37.7227881560287, -122.402019710862) | 10 | 3 | 7 | 309 | 28 | |||
156122 | 115979 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011610.19593 | 2091240.25279 | 37.7228018257296 | -122.401963063449 | (37.7228018257296, -122.401963063449) | 10 | 3 | 7 | 309 | 28 | |||
12009 | 162257 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 778 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6011373.11147 | 2091245.9028 | 37.7228041046152 | -122.402783015826 | (37.7228041046152, -122.402783015826) | 10 | 3 | 7 | 309 | 28 | |||
158751 | 115978 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011623.9012 | 2091244.95295 | 37.7228154963084 | -122.40191601721 | (37.7228154963084, -122.40191601721) | 10 | 3 | 7 | 309 | 28 | |||
188951 | 115977 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011639.0005 | 2091249.90123 | 37.7228299259539 | -122.40186416949 | (37.7228299259539, -122.40186416949) | 10 | 3 | 7 | 309 | 28 | |||
163344 | 115976 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011653.53869 | 2091254.58415 | 37.7228435956385 | -122.401814242757 | (37.7228435956385, -122.401814242757) | 10 | 3 | 7 | 309 | 28 | |||
180595 | 177435 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010088.68836 | 2091439.32967 | 37.7232634144668 | -122.407236642978 | (37.7232634144668, -122.407236642978) | 10 | 3 | 7 | 309 | 28 | |||
21174 | 177436 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99 Karen Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010107.2934 | 2091444.47715 | 37.7232785896114 | -122.407172691281 | (37.7232785896114, -122.407172691281) | 10 | 3 | 7 | 309 | 28 | |||
131019 | 114688 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 231 Dwight St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | Permit Number 774702 | 6010865.8 | 2091429.3 | 37.7232793364177 | -122.404549596707 | (37.7232793364177, -122.404549596707) | 10 | 3 | 7 | 309 | 28 | |||
151875 | 177437 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 93 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010115.68283 | 2091447.62238 | 37.7232876952637 | -122.407143912081 | (37.7232876952637, -122.407143912081) | 10 | 3 | 7 | 309 | 28 | |||
129691 | 114755 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 89 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777135 | 6010155.72688 | 2091460.80739 | 37.7233261394813 | -122.407006415641 | (37.7233261394813, -122.407006415641) | 10 | 3 | 7 | 309 | 28 | ||
139230 | 177438 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 83 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010165.7616 | 2091462.99776 | 37.7233327153139 | -122.406971881647 | (37.7233327153139, -122.406971881647) | 10 | 3 | 7 | 309 | 28 | |||
186074 | 177439 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010188.86492 | 2091471.00105 | 37.7233559834822 | -122.406892581232 | (37.7233559834822, -122.406892581232) | 10 | 3 | 7 | 309 | 28 | |||
86141 | 88503 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 7 Wheat St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51441 | 6012178 | 2091435 | 37.7233682355202 | -122.400013942822 | (37.7233682355202, -122.400013942822) | 10 | 3 | 8 | 58 | 1 | |||
103818 | 177440 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 71 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010238.57006 | 2091486.20011 | 37.7234004981218 | -122.406721829644 | (37.7234004981218, -122.406721829644) | 10 | 3 | 7 | 309 | 28 | |||
40320 | 177441 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 71 Karen Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010258.66598 | 2091491.87018 | 37.7234171913236 | -122.406652760812 | (37.7234171913236, -122.406652760812) | 10 | 3 | 7 | 309 | 28 | |||
189282 | 177442 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 67 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010267.21749 | 2091493.90642 | 37.7234232608607 | -122.406623343098 | (37.7234232608607, -122.406623343098) | 10 | 3 | 7 | 309 | 28 | |||
92349 | 177443 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 63 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010306.59987 | 2091507.00491 | 37.7234614298874 | -122.406488127328 | (37.7234614298874, -122.406488127328) | 10 | 3 | 7 | 309 | 28 | |||
146233 | 208845 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 277 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995629.339 | 2091829.15928 | 37.7235139565963 | -122.457247722532 | (37.7235139565963, -122.457247722532) | 9 | 8 | 4 | 28861 | 24 | |||
62070 | 115256 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 277 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 773180 | 5995612.8 | 2091840.6 | 37.7235444201772 | -122.457305721784 | (37.7235444201772, -122.457305721784) | 9 | 8 | 4 | 28861 | 24 | |||
104830 | 177444 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 15 Karen Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010486.61044 | 2091547.46792 | 37.7235826018289 | -122.40586870937 | (37.7235826018289, -122.40586870937) | 10 | 3 | 7 | 309 | 28 | |||
39488 | 177445 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 15 Karen Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6010506.33995 | 2091553.32971 | 37.7235998004623 | -122.405800920297 | (37.7235998004623, -122.405800920297) | 10 | 3 | 7 | 309 | 28 | |||
58994 | 114753 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777133 | 6010495.97692 | 2091580.43732 | 37.7236736527876 | -122.405838652231 | (37.7236736527876, -122.405838652231) | 10 | 3 | 7 | 309 | 28 | ||
180340 | 208846 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 36 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995163.31564 | 2091909.32906 | 37.7237073072365 | -122.45886447242 | (37.7237073072365, -122.45886447242) | 9 | 8 | 4 | 28861 | 24 | |||
109571 | 177421 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 0 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6001079.38248 | 2091791.86287 | 37.7237230579705 | -122.438405269984 | (37.7237230579705, -122.438405269984) | 9 | 7 | 6 | 28861 | 25 | |||
155652 | 177422 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 0 Santa Ynez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6001061.39064 | 2091803.12496 | 37.7237529577069 | -122.438468271097 | (37.7237529577069, -122.438468271097) | 9 | 7 | 6 | 28861 | 25 | |||
14384 | 65195 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 277 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 2 | Permit Number 27179 | 6002900.88646 | 2091805.07241 | 37.7238627685341 | -122.432109587587 | (37.7238627685341, -122.432109587587) | 9 | 7 | 6 | 28861 | 5 | |
49485 | 95113 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 887 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54041 | 6001057 | 2091844.3 | 37.7238657652599 | -122.438486397461 | (37.7238657652599, -122.438486397461) | 9 | 7 | 6 | 28861 | 25 | |
157732 | 114754 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 83 Karen Ct | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2015 12:00:00 AM | Permit Number 777134 | 6010271.6 | 2091687.4 | 37.7239547991887 | -122.406621822462 | (37.7239547991887, -122.406621822462) | 10 | 3 | 7 | 309 | 28 | ||||
62045 | 49067 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1298 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50555 | 5995836.31315767 | 2092013.47244835 | 37.7240319217297 | -122.45654557668 | (37.7240319217297, -122.45654557668) | 9 | 8 | 4 | 28861 | 40 | ||
26931 | 37803 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 465 Woolsey St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010402.90992445 | 2091781.87036726 | 37.7242215408534 | -122.406174555323 | (37.7242215408534, -122.406174555323) | 10 | 3 | 7 | 309 | 28 | ||
53411 | 114722 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 465 Woolsey St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010466.6 | 2091788 | 37.7242419338513 | -122.405954818575 | (37.7242419338513, -122.405954818575) | 10 | 3 | 7 | 309 | 28 | |||
80677 | 114721 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 465 Woolsey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010466.6 | 2091788 | 37.7242419338513 | -122.405954818575 | (37.7242419338513, -122.405954818575) | 10 | 3 | 7 | 309 | 28 | |||
174661 | 114720 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 465 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010466.6 | 2091788 | 37.7242419338513 | -122.405954818575 | (37.7242419338513, -122.405954818575) | 10 | 3 | 7 | 309 | 28 | |||
81820 | 104632 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 323 Madrid St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2014 12:00:00 AM | 3 | Permit Number 773809 | 6003337.3 | 2091944.5 | 37.7242703388921 | -122.430610922244 | (37.7242703388921, -122.430610922244) | 9 | 7 | 6 | 28861 | 5 | |||
102452 | 177446 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 323 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6003320.62443 | 2091964.27953 | 37.7243237043587 | -122.43066997804 | (37.7243237043587, -122.43066997804) | 9 | 7 | 6 | 28861 | 5 | |||
26576 | 173651 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 80 Entrada Ct | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/21/2016 12:00:00 AM | 3 | 4x10 | 5992424.45657 | 2092194.59394 | 37.7243327619491 | -122.468352901223 | (37.7243327619491, -122.468352901223) | 9 | 8 | 4 | 59 | 40 | ||
168722 | 110031 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 92X Santa Ynez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774272 | 6000673.3536 | 2092054.19092 | 37.7244202473951 | -122.439827638683 | (37.7244202473951, -122.439827638683) | 9 | 7 | 6 | 28861 | 25 |
98737 | 108845 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 420 Woolsey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010479.05335 | 2091857.99264 | 37.7244348155857 | -122.405916697196 | (37.7244348155857, -122.405916697196) | 10 | 3 | 7 | 309 | 28 | |
189937 | 108842 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 420 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010509.54502 | 2091864.19266 | 37.7244535448266 | -122.405811727659 | (37.7244535448266, -122.405811727659) | 10 | 3 | 7 | 309 | 28 | |
107527 | 108843 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 420 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010519.10921 | 2091869.71455 | 37.7244692416558 | -122.405779054162 | (37.7244692416558, -122.405779054162) | 10 | 3 | 7 | 309 | 28 | |
44619 | 177424 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 85 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000559.94682 | 2092109.10715 | 37.7245645787726 | -122.440223605655 | (37.7245645787726, -122.440223605655) | 9 | 7 | 6 | 28861 | 25 | |||
96875 | 177423 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 270 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999939.77666 | 2092147.85861 | 37.7246356530907 | -122.442370227117 | (37.7246356530907, -122.442370227117) | 9 | 7 | 6 | 28861 | 25 | |||
96870 | 87781 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 270 Delano Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50517 | 5999921.6 | 2092148.7 | 37.7246369273224 | -122.442433121703 | (37.7246369273224, -122.442433121703) | 9 | 7 | 6 | 28861 | 25 | |||
821 | 261708 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 1 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
12273 | 261709 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 2 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
139488 | 88514 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 640 Faxon Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51446 | 5994921.4 | 2092497.3 | 37.7253078255283 | -122.459743296133 | (37.7253078255283, -122.459743296133) | 9 | 7 | 4 | 28861 | 40 | |||
93952 | 50024 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1704 Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 3 | Permit Number 46757 | 6005953.21642 | 2092396.45471 | 37.7256591580411 | -122.421600147046 | (37.7256591580411, -122.421600147046) | 9 | 7 | 7 | 309 | 5 | |
6755 | 264922 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Urbano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 4x6 | Permit Number 781481 | 5992625.08037 | 2092677.96132 | 37.7256715559054 | -122.467694516591 | (37.7256715559054, -122.467694516591) | 9 | 8 | 4 | 59 | 40 | |
15881 | 264923 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Urbano Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 4x6 | Permit Number 781481 | 5992625.08037 | 2092677.96132 | 37.7256715559054 | -122.467694516591 | (37.7256715559054, -122.467694516591) | 9 | 8 | 4 | 59 | 40 | |
166450 | 177431 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 268 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6005673.42273 | 2092431.00226 | 37.7257382372047 | -122.42256982665 | (37.7257382372047, -122.42256982665) | 9 | 7 | 7 | 309 | 5 | |||
4377 | 88323 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 125 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51312 | 6003417 | 2092629 | 37.7261543381556 | -122.430384225952 | (37.7261543381556, -122.430384225952) | 9 | 7 | 6 | 28861 | 5 | |||
17 | 164866 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 719 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 4x6 | Permit Number 782492 | 5994853.78052 | 2092811.30491 | 37.7261661184654 | -122.459999785581 | (37.7261661184654, -122.459999785581) | 9 | 7 | 4 | 28861 | 40 | |
186183 | 43147 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 249 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767437 | 6005979.23995 | 2092615.63792 | 37.7262624547464 | -122.421525745221 | (37.7262624547464, -122.421525745221) | 9 | 7 | 7 | 309 | 5 |
79752 | 43146 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 243 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2015 12:00:00 AM | 1 | Permit Number 774635 | 6005976.40354 | 2092622.55461 | 37.7262812865364 | -122.421536041574 | (37.7262812865364, -122.421536041574) | 9 | 7 | 7 | 309 | 5 | |
41323 | 177426 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 125 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6003455.72001 | 2092686.06716 | 37.7263132250654 | -122.430254442684 | (37.7263132250654, -122.430254442684) | 9 | 7 | 6 | 28861 | 5 | |||
135244 | 43160 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 261 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767438 | 6006282.82959 | 2092642.15817 | 37.7263523869376 | -122.420478131265 | (37.7263523869376, -122.420478131265) | 9 | 7 | 7 | 309 | 5 |
73463 | 208840 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1350 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995903.35402 | 2092975.62657 | 37.7266776159651 | -122.456383367909 | (37.7266776159651, -122.456383367909) | 9 | 7 | 4 | 28861 | 40 | |||
172305 | 37859 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 127 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | 6 | Permit Number 47618 | 6004006.38058 | 2093054.46604 | 37.7273559413142 | -122.428377081834 | (37.7273559413142, -122.428377081834) | 9 | 7 | 6 | 28861 | 5 | |
117325 | 30768 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1639 Wallace Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 1 | Permit Number 34648 | 6014552.699 | 2093014.6387 | 37.7278377210513 | -122.391915390574 | (37.7278377210513, -122.391915390574) | 10 | 3 | 8 | 58 | 1 | |
4664 | 171655 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 101 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6007664.95872 | 2093252.16101 | 37.7281051161408 | -122.415743336498 | (37.7281051161408, -122.415743336498) | 9 | 3 | 7 | 309 | 5 | |||
15945 | 262454 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 230 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 6001065 | 2093436 | 37.7282366652571 | -122.438572735463 | (37.7282366652571, -122.438572735463) | 9 | 7 | 6 | 28861 | 25 | ||
190423 | 177420 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 121 Cotter St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6001985.26237 | 2093449.72899 | 37.7283266686193 | -122.435392337892 | (37.7283266686193, -122.435392337892) | 9 | 7 | 6 | 28861 | 25 | |||
50384 | 208857 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1 Gennessee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5997408.76137 | 2093610.56673 | 37.7285073190505 | -122.451225020336 | (37.7285073190505, -122.451225020336) | 9 | 7 | 4 | 28861 | 40 | |||
141670 | 62233 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 120 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 3 | Permit Number 22359 | 6001435.36273 | 2093541.49048 | 37.7285473793362 | -122.437299929461 | (37.7285473793362, -122.437299929461) | 9 | 7 | 6 | 28861 | 25 | |
116128 | 177419 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 100 Capistrano Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001443.85417 | 2093560.72279 | 37.7286006695825 | -122.437271950666 | (37.7286006695825, -122.437271950666) | 9 | 7 | 6 | 28861 | 25 | |||
2285 | 95676 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 232 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767428 | 6010063.65694 | 2093465.10714 | 37.7288243741431 | -122.407465923318 | (37.7288243741431, -122.407465923318) | 10 | 3 | 7 | 309 | 28 |
40470 | 87788 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 114 Theresa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.434669544642 | (37.7289708079503, -122.434669544642) | 9 | 7 | 6 | 28861 | 25 | |||
89811 | 87785 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 114 Theresa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.434669544642 | (37.7289708079503, -122.434669544642) | 9 | 7 | 6 | 28861 | 25 | |||
157236 | 87786 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 114 Theresa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.434669544642 | (37.7289708079503, -122.434669544642) | 9 | 7 | 6 | 28861 | 25 | |||
164923 | 87787 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 114 Theresa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.434669544642 | (37.7289708079503, -122.434669544642) | 9 | 7 | 6 | 28861 | 25 | |||
62802 | 110565 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 135 Theresa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x9 | 6002103.51268 | 2093689.48997 | 37.7289917127743 | -122.435000682233 | (37.7289917127743, -122.435000682233) | 9 | 7 | 6 | 28861 | 25 | |||
47926 | 110564 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 135 Theresa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x9 | 6002092.75194 | 2093699.46339 | 37.7290184865087 | -122.435038595882 | (37.7290184865087, -122.435038595882) | 9 | 7 | 6 | 28861 | 25 | |||
33505 | 110563 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 135 Theresa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x9 | 6002082.974 | 2093709.61136 | 37.7290457953117 | -122.435073124425 | (37.7290457953117, -122.435073124425) | 9 | 7 | 6 | 28861 | 25 | |||
141135 | 110562 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 135 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x9 | 6002071.86629 | 2093721.73728 | 37.7290784595956 | -122.43511239152 | (37.7290784595956, -122.43511239152) | 9 | 7 | 6 | 28861 | 25 | |||
121231 | 27188 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 258 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2002 12:00:00 AM | 5 | 2X3 | 6002908.14927 | 2093727.2885 | 37.7291411540255 | -122.43222169349 | (37.7291411540255, -122.43222169349) | 9 | 7 | 6 | 28861 | 25 | ||
30764 | 97025 | Property Tree 8 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
126802 | 254628 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 210 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781525 | 6004782.66269 | 2093766.92621 | 37.7293560955828 | -122.425744162451 | (37.7293560955828, -122.425744162451) | 9 | 7 | 6 | 28861 | 5 |
138659 | 109684 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773450 | 6005044.41141 | 2093779.7607 | 37.7294061239723 | -122.42484018495 | (37.7294061239723, -122.42484018495) | 9 | 7 | 6 | 28861 | 5 |
69609 | 109685 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 266 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775044 | 6005143.37702 | 2093783.49451 | 37.7294219655289 | -122.424498316649 | (37.7294219655289, -122.424498316649) | 9 | 7 | 6 | 28861 | 5 |
147550 | 113269 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1328 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | Permit Number 774425 | 6016744.9 | 2093624.7 | 37.7296342890732 | -122.384379303046 | (37.7296342890732, -122.384379303046) | 10 | 3 | 8 | 58 | 1 | |||
1002 | 260458 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 835 Darien Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/19/2019 12:00:00 AM | 3 | 6x10 | Permit Number 784514 | 5994066 | 2094094 | 37.7296427463027 | -122.462816092129 | (37.7296427463027, -122.462816092129) | 9 | 8 | 4 | 59 | 40 | |
85856 | 52415 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 445 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50993 | 5997805.99655674 | 2094075.37872241 | 37.729806319232 | -122.449885248514 | (37.729806319232, -122.449885248514) | 9 | 7 | 4 | 28861 | 40 | ||
151899 | 108558 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 222 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773717 | 6001903.01628 | 2093995.18892 | 37.7298197060157 | -122.435715674761 | (37.7298197060157, -122.435715674761) | 9 | 7 | 6 | 28861 | 25 |
38952 | 177433 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 439 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008733.06168 | 2093861.61414 | 37.7298385306021 | -122.412093908309 | (37.7298385306021, -122.412093908309) | 9 | 3 | 7 | 309 | 28 | |||
123198 | 61691 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 61 Lucy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 4 | Permit Number 31258 | 6014147.06906 | 2093799.26826 | 37.7299696274983 | -122.393372558494 | (37.7299696274983, -122.393372558494) | 10 | 3 | 8 | 58 | 1 | |
64837 | 253415 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 Stoneybrook Ave | Front Yard : Cutout | Tree | Private 2 | 08/31/2017 12:00:00 AM | 3 | Permit Number 779907 | 6005926.97731 | 2093972.42686 | 37.7299849530428 | -122.421802746417 | (37.7299849530428, -122.421802746417) | 9 | 7 | 6 | 28861 | 5 | |||
152292 | 177427 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 145 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004319.85704 | 2094053.89798 | 37.7301178924245 | -122.427364559453 | (37.7301178924245, -122.427364559453) | 9 | 7 | 6 | 28861 | 5 | |||
21267 | 177432 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 66 Gladstone Dr | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6006350.82649 | 2094014.80407 | 37.730125204807 | -122.420340452271 | (37.730125204807, -122.420340452271) | 9 | 7 | 7 | 28861 | 5 | |||
48747 | 177428 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 274 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005170.17326 | 2094055.30176 | 37.7301698012868 | -122.424425004805 | (37.7301698012868, -122.424425004805) | 9 | 7 | 6 | 28861 | 5 | |||
32238 | 177429 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 278 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005195.23308 | 2094056.19803 | 37.7301736773527 | -122.424338433387 | (37.7301736773527, -122.424338433387) | 9 | 7 | 6 | 28861 | 5 | |||
94665 | 177430 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 294 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005292.64234 | 2094059.99778 | 37.73018961064 | -122.424001946647 | (37.73018961064, -122.424001946647) | 9 | 7 | 6 | 28861 | 5 | |||
157993 | 177434 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 131 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781326 | 6010258.4147 | 2094004.87757 | 37.7303173692474 | -122.406830655731 | (37.7303173692474, -122.406830655731) | 10 | 3 | 7 | 309 | 28 |
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) );