trees
6,344 rows where qSpecies_id = 19 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
115043 | 33676 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 455 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773435 | 6005180.13897934 | 2111093.89138396 | 37.776954366261 | -122.425602743023 | (37.776954366261, -122.425602743023) | 7 | 9 | 11 | 28852 | 10 | ||
115349 | 229456 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004163.15543 | 2110003.15214 | 37.7739019474441 | -122.429043014529 | (37.7739019474441, -122.429043014529) | 7 | 9 | 11 | 28852 | 10 | |||
116278 | 108013 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 419X Ivy St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773433 | 6005343.63147 | 2111122.79579 | 37.7770429674219 | -122.425039228843 | (37.7770429674219, -122.425039228843) | 7 | 9 | 11 | 28852 | 10 | ||
117615 | 69388 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 300X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/2001 12:00:00 AM | Permit Number 43603 | 6005119 | 2109916 | 37.7737167085248 | -122.425730383611 | (37.7737167085248, -122.425730383611) | 7 | 9 | 11 | 28852 | 10 | ||
120114 | 47004 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 500 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45002 | 6004637 | 2110246 | 37.7745955592359 | -122.427421211008 | (37.7745955592359, -122.427421211008) | 7 | 9 | 11 | 28852 | 10 | ||
127608 | 76051 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
127874 | 33637 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 422 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | 2 | Permit Number 47249 | 6005338.8371 | 2110808.4043 | 37.7761794541787 | -122.425033439554 | (37.7761794541787, -122.425033439554) | 7 | 9 | 11 | 28852 | 10 | ||
131450 | 16937 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 553 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/03/1997 12:00:00 AM | 6 | 3X3 | 6004340.6432 | 2110109.6362 | 37.7742043718245 | -122.428436646262 | (37.7742043718245, -122.428436646262) | 7 | 9 | 11 | 28852 | 10 | ||
135220 | 138853 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 521 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004867.6169 | 2111067.8223 | 37.7768651230667 | -122.426681996592 | (37.7768651230667, -122.426681996592) | 7 | 9 | 11 | 28852 | 10 | |||
137239 | 138878 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 660 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004189.3388 | 2110489.5922 | 37.7752390747268 | -122.428987130379 | (37.7752390747268, -122.428987130379) | 7 | 9 | 11 | 28852 | 10 | |||
137986 | 244939 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 320 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6005140.4413 | 2109999.008 | 37.7739458399346 | -122.425662123899 | (37.7739458399346, -122.425662123899) | 7 | 9 | 11 | 28852 | 10 | |||
138990 | 110337 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 501x IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x3 | 6004921 | 2111009 | 37.7767066293551 | -122.426493138757 | (37.7767066293551, -122.426493138757) | 7 | 9 | 11 | 28852 | 10 | ||||
140888 | 52108 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 524 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | 4 | Permit Number 48300 | 6005253.0532 | 2111327.8718 | 37.7776009390586 | -122.425367164849 | (37.7776009390586, -122.425367164849) | 7 | 9 | 11 | 28852 | 10 | |
141305 | 37431 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 536 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42931 | 6008426.54178738 | 2114301.85272744 | 37.7859455606353 | -122.414599468607 | (37.7859455606353, -122.414599468607) | 5 | 10 | 9 | 28852 | 36 | ||
143302 | 33673 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 630 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 9 | Permit Number 37755 | 6004321.4798 | 2111011.3928 | 37.7766792898809 | -122.428567227188 | (37.7766792898809, -122.428567227188) | 7 | 9 | 11 | 28852 | 10 | ||
143385 | 244937 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 300 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005146.519 | 2109950.3868 | 37.7738126813471 | -122.425637638903 | (37.7738126813471, -122.425637638903) | 7 | 9 | 11 | 28852 | 10 | |||
144073 | 138884 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 683 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004099.6041 | 2110615.1538 | 37.7755787562949 | -122.429306498631 | (37.7755787562949, -122.429306498631) | 7 | 9 | 11 | 28852 | 10 | |||
144866 | 43095 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | 12 | Permit Number 42929 | 6008429.70971 | 2114260.99148 | 37.7858335435152 | -122.41458561586 | (37.7858335435152, -122.41458561586) | 5 | 10 | 9 | 28852 | 36 | ||
149923 | 138194 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 667 LINDEN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004269.3633 | 2110634.2391 | 37.7756407689969 | -122.428720621078 | (37.7756407689969, -122.428720621078) | 7 | 9 | 11 | 28852 | 10 | |||
150029 | 249390 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 240 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6008867.77806 | 2113219.38009 | 37.7829981304131 | -122.412996342018 | (37.7829981304131, -122.412996342018) | 7 | 10 | 9 | 28852 | 36 | |||
151184 | 41601 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 11 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2006 12:00:00 AM | Permit Number 48810 | 6006168.11250893 | 2109650.54781373 | 37.7730470683498 | -122.422082471983 | (37.7730470683498, -122.422082471983) | 7 | 2 | 11 | 28852 | 10 | |||
151323 | 249394 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 350 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008338.39632 | 2113145.81532 | 37.7827664083955 | -122.414822582709 | (37.7827664083955, -122.414822582709) | 7 | 10 | 9 | 28852 | 36 | |||
152931 | 41600 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 11 Haight St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2006 12:00:00 AM | Permit Number 48810 | 6006168.11250893 | 2109650.54781373 | 37.7730470683498 | -122.422082471983 | (37.7730470683498, -122.422082471983) | 7 | 2 | 11 | 28852 | 10 | |||
155037 | 138891 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 671 LINDEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004218.1342 | 2110627.8774 | 37.775620401834 | -122.428897381495 | (37.775620401834, -122.428897381495) | 7 | 9 | 11 | 28852 | 10 | |||
155095 | 43094 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 590 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | 13 | Permit Number 42929 | 6008493.83084 | 2114205.79607 | 37.7856855924574 | -122.414359867126 | (37.7856855924574, -122.414359867126) | 5 | 10 | 9 | 28852 | 36 | ||
156201 | 27337 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 638 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/1998 12:00:00 AM | 3 | 4X4 | 6004363.19839 | 2110524.63458 | 37.7753451321029 | -122.428388208625 | (37.7753451321029, -122.428388208625) | 7 | 9 | 11 | 28852 | 10 | ||
157540 | 138195 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 667 LINDEN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004281.7521 | 2110633.5695 | 37.7756396315887 | -122.428677717424 | (37.7756396315887, -122.428677717424) | 7 | 9 | 11 | 28852 | 10 | |||
158031 | 138896 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 610 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004465.072 | 2110685.9705 | 37.7757938851349 | -122.428047303691 | (37.7757938851349, -122.428047303691) | 7 | 9 | 11 | 28852 | 10 | |||
159694 | 76205 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
159761 | 26488 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005009.61064 | 2110928.03079 | 37.7764893165108 | -122.426180842363 | (37.7764893165108, -122.426180842363) | 7 | 9 | 11 | 28852 | 10 | |||
162910 | 112641 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 299X STOCKTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6x6 | 6010693 | 2115178 | 37.7884783251045 | -122.406819877074 | (37.7884783251045, -122.406819877074) | 5 | 1 | 10 | 28852 | 6 | |||
162913 | 27343 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 658 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/1998 12:00:00 AM | 3 | 4X4 | 6004282.41706 | 2110648.93551 | 37.7756818605142 | -122.428676512776 | (37.7756818605142, -122.428676512776) | 7 | 9 | 11 | 28852 | 10 | ||
163211 | 138847 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 618 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004997.1634 | 2111032.5188 | 37.7767755115034 | -122.42623134169 | (37.7767755115034, -122.42623134169) | 7 | 9 | 11 | 28852 | 10 | |||
166831 | 108008 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 419X Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773433 | 6005343.63147 | 2111122.79579 | 37.7770429674219 | -122.425039228843 | (37.7770429674219, -122.425039228843) | 7 | 9 | 11 | 28852 | 10 | ||
167966 | 76185 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
168248 | 229460 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004174.78123 | 2109923.65929 | 37.7736843376079 | -122.428997130237 | (37.7736843376079, -122.428997130237) | 7 | 9 | 11 | 28852 | 10 | |||
170019 | 9668 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 189X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2012 12:00:00 AM | 3 | 3X3 | 6006090.09804 | 2110353.58186 | 37.7749730301161 | -122.422402296452 | (37.7749730301161, -122.422402296452) | 7 | 9 | 11 | 28852 | 10 | ||
171389 | 229452 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6004615.74845 | 2110238.33012 | 37.774573297652 | -122.427494177811 | (37.774573297652, -122.427494177811) | 7 | 9 | 11 | 28852 | 10 | |||
172444 | 229461 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004176.03867 | 2109904.23268 | 37.7736310680655 | -122.42899139523 | (37.7736310680655, -122.42899139523) | 7 | 9 | 11 | 28852 | 10 | |||
172632 | 229459 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004169.38013 | 2109943.17099 | 37.7737376062358 | -122.429017204892 | (37.7737376062358, -122.429017204892) | 7 | 9 | 11 | 28852 | 10 | |||
173476 | 245844 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 409 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005035.4312 | 2110374.2843 | 37.77497032308 | -122.426052092189 | (37.77497032308, -122.426052092189) | 7 | 9 | 11 | 28852 | 10 | |||
176791 | 246513 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Laguna St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6005253.79873 | 2109165.70354 | 37.7716641922687 | -122.425210693923 | (37.7716641922687, -122.425210693923) | 7 | 9 | 5 | 28852 | 10 | |||
181105 | 51686 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 518@ WEBSTER Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | Permit Number 47966 | 6004499.81442005 | 2110183.79771446 | 37.7744170070757 | -122.427891329901 | (37.7744170070757, -122.427891329901) | 7 | 9 | 11 | 28852 | 10 | |||
183861 | 108020 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 552 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773435 | 6005205.24822 | 2111000.9732 | 37.7767006543612 | -122.425509267978 | (37.7767006543612, -122.425509267978) | 7 | 9 | 11 | 28852 | 10 | ||
185116 | 138876 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 634 FELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004312.5565 | 2110504.3248 | 37.7752865006605 | -122.428561942685 | (37.7752865006605, -122.428561942685) | 7 | 9 | 11 | 28852 | 10 | |||
185214 | 229457 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004166.88203 | 2109982.84925 | 37.773846411623 | -122.429028675758 | (37.773846411623, -122.429028675758) | 7 | 9 | 11 | 28852 | 10 | |||
190289 | 43100 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 536 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | Permit Number 42931 | 6008426.54178738 | 2114301.85272744 | 37.7859455606353 | -122.414599468607 | (37.7859455606353, -122.414599468607) | 5 | 10 | 9 | 28852 | 36 | |||
192959 | 76112 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
193408 | 33635 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 420 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | 3 | Permit Number 47248 | 6005355.3541 | 2110810.4186 | 37.776185917952 | -122.42497644607 | (37.776185917952, -122.42497644607) | 7 | 9 | 11 | 28852 | 10 | ||
194137 | 27344 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 664 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/1998 12:00:00 AM | 3 | 4X4 | 6004282.41706 | 2110648.93551 | 37.7756818605142 | -122.428676512776 | (37.7756818605142, -122.428676512776) | 7 | 9 | 11 | 28852 | 10 | ||
1761 | 193283 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1628 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007524.2032 | 2108954.2313 | 37.7712115401103 | -122.417342217788 | (37.7712115401103, -122.417342217788) | 8 | 2 | 9 | 28853 | 19 | |||
2065 | 849 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 109X POTRERO AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 36 | 3x3 | Permit Number 777000 | 6010279 | 2107809 | 37.7682216042911 | -122.407732456911 | (37.7682216042911, -122.407732456911) | 8 | 4 | 8 | 28853 | 19 | |
2439 | 152111 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 61 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6006504.58335 | 2108147.23788 | 37.7689383093717 | -122.420811828315 | (37.7689383093717, -122.420811828315) | 8 | 4 | 7 | 28853 | 19 | |||
2668 | 85700 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 918 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010976.81813 | 2112473.48761 | 37.7810682491478 | -122.405647340366 | (37.7810682491478, -122.405647340366) | 14 | 2 | 9 | 28853 | 34 | ||
3063 | 192918 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009145.73706 | 2109144.68728 | 37.7718255855015 | -122.411746706156 | (37.7718255855015, -122.411746706156) | 8 | 2 | 9 | 28853 | 34 | |||
3248 | 85701 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 926 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010962.65697 | 2112458.52521 | 37.781026374014 | -122.405695276931 | (37.781026374014, -122.405695276931) | 14 | 2 | 9 | 28853 | 34 | ||
3769 | 39565 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 340 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 7 | Permit Number 40986 | 6011421.0186 | 2106801.06955 | 37.765517919653 | -122.403711377001 | (37.765517919653, -122.403711377001) | 8 | 3 | 8 | 28853 | 20 | |
3961 | 79969 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1209 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6009151.65519 | 2110631.00796 | 37.7759070057295 | -122.411831280182 | (37.7759070057295, -122.411831280182) | 8 | 2 | 9 | 28853 | 34 | |||
4003 | 193246 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 843 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011569.59394 | 2112947.98567 | 37.7824042397005 | -122.40363001712 | (37.7824042397005, -122.40363001712) | 6 | 2 | 9 | 28853 | 34 | |||
4575 | 29055 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 400X 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008920.1536798 | 2108682.7358637 | 37.7705445174102 | -122.412494357701 | (37.7705445174102, -122.412494357701) | 8 | 2 | 9 | 28853 | 19 | ||
4855 | 76107 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 60 Rausch St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009843.66078 | 2110720.8424 | 37.7761924676323 | -122.409443785198 | (37.7761924676323, -122.409443785198) | 8 | 2 | 9 | 28853 | 34 | |||
5051 | 192939 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1559 Howard St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6007881.70364 | 2109409.76028 | 37.7724824224706 | -122.416137872687 | (37.7724824224706, -122.416137872687) | 8 | 2 | 9 | 28853 | 19 | |||
6085 | 82927 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1140 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6010031.8585 | 2110690.2274 | 37.7761189490017 | -122.40879059487 | (37.7761189490017, -122.40879059487) | 8 | 2 | 9 | 28853 | 34 | ||
6531 | 192922 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 10th St | 6 | : | Tree | Private 2 | 2 | Width 3ft | 6009195.26787 | 2109094.7407 | 37.7716912222994 | -122.411571845561 | (37.7716912222994, -122.411571845561) | 8 | 2 | 9 | 28853 | 34 | |||
7326 | 98693 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1400X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 48713 | 6009268 | 2109041 | 37.7715477423488 | -122.411316462549 | (37.7715477423488, -122.411316462549) | 8 | 2 | 9 | 28853 | 34 | ||
7871 | 104619 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | MTA | 7 | 4x4 | Permit Number 770959 | 6012190.226 | 2112753.6665 | 37.7819053332353 | -122.401469228728 | (37.7819053332353, -122.401469228728) | 6 | 2 | 9 | 28853 | 34 | |
8073 | 64439 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 40 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1988 12:00:00 AM | 15 | Permit Number 25301 | 6009724.66306 | 2110846.10571 | 37.7765297431014 | -122.409864276736 | (37.7765297431014, -122.409864276736) | 8 | 2 | 9 | 28853 | 34 | |
8419 | 85699 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 918 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010993.40445 | 2112488.15858 | 37.7811094596721 | -122.405590993329 | (37.7811094596721, -122.405590993329) | 14 | 2 | 9 | 28853 | 34 | ||
8772 | 42026 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 49 Rausch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 6 | Permit Number 42349 | 6009754.59547 | 2110863.51813 | 37.776579230974 | -122.409761960854 | (37.776579230974, -122.409761960854) | 8 | 2 | 9 | 28853 | 34 | |
8967 | 18314 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 180 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782360 | 6010236.79256 | 2107510.48621 | 37.7673995909374 | -122.407857396411 | (37.7673995909374, -122.407857396411) | 8 | 4 | 8 | 28853 | 19 | |
8989 | 70675 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 49 Rausch St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6009740.45587 | 2110875.89947 | 37.7766124348397 | -122.409811748212 | (37.7766124348397, -122.409811748212) | 8 | 2 | 9 | 28853 | 34 | |||
9409 | 76076 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 60 Rausch St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6009855.80512 | 2110709.84536 | 37.7761629527799 | -122.409400998174 | (37.7761629527799, -122.409400998174) | 8 | 2 | 9 | 28853 | 34 | |||
9422 | 80211 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 340 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008650.63461 | 2108952.54787 | 37.7712702289655 | -122.413445714359 | (37.7712702289655, -122.413445714359) | 8 | 2 | 9 | 28853 | 19 | |||
9918 | 74256 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1126X Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6009656.55619 | 2111209.09392 | 37.7775226063216 | -122.410125511783 | (37.7775226063216, -122.410125511783) | 8 | 2 | 9 | 28853 | 34 | |||
10244 | 82748 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1434-1436 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6008231.53118 | 2109847.29583 | 37.7737034553791 | -122.414958754439 | (37.7737034553791, -122.414958754439) | 8 | 2 | 9 | 28853 | 34 | |||
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 | ||
10748 | 92022 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 230 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2009 12:00:00 AM | 3x3 | Permit Number 770960 | 6011866.1 | 2113060.9 | 37.7827308344341 | -122.402612173234 | (37.7827308344341, -122.402612173234) | 6 | 2 | 9 | 28853 | 34 | ||
11033 | 70684 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 90 Moss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6010365.45358 | 2111155.37964 | 37.7774148279639 | -122.407669399445 | (37.7774148279639, -122.407669399445) | 14 | 2 | 9 | 28853 | 34 | |||
11447 | 49551 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1084REVISED Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2020 01:56:00 PM | 3 | Permit Number 46441 | 6009968.28689 | 2111507.46699 | 37.7783593364429 | -122.409068185146 | (37.7783593364429, -122.409068185146) | 14 | 2 | 9 | 28853 | 34 | ||
12021 | 31607 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 5 Lucerne St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/1995 12:00:00 AM | 9 | Permit Number 35133 | 6012055.45942 | 2109792.65137 | 37.7737675473795 | -122.40172727021 | (37.7737675473795, -122.40172727021) | 14 | 2 | 9 | 28853 | 34 | ||
12170 | 70672 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 30 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6009676.94569 | 2110892.33688 | 37.7766540087164 | -122.410032610029 | (37.7766540087164, -122.410032610029) | 8 | 2 | 9 | 28853 | 34 | |||
12426 | 85702 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 926 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010947.05257 | 2112444.31834 | 37.7809864926601 | -122.405748259582 | (37.7809864926601, -122.405748259582) | 14 | 2 | 9 | 28853 | 34 | ||
12660 | 255643 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1122 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6010085.7211 | 2110745.2484 | 37.7762730405804 | -122.408608151117 | (37.7762730405804, -122.408608151117) | 8 | 2 | 9 | 28853 | 34 | ||||
12681 | 42027 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 49 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 11 | 3x3 | Permit Number 42349 | 6009766.86792 | 2110848.40858 | 37.7765384314298 | -122.409718439962 | (37.7765384314298, -122.409718439962) | 8 | 2 | 9 | 28853 | 34 |
13626 | 82968 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 75X Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 775675 | 6010000.91561265 | 2110652.98797709 | 37.7760149650505 | -122.408895007094 | (37.7760149650505, -122.408895007094) | 8 | 2 | 9 | 28853 | 34 | |
15923 | 5379 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 299 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4X4 | 6004899.9834 | 2106715.40982 | 37.764916280383 | -122.426260083162 | (37.764916280383, -122.426260083162) | 8 | 4 | 5 | 28853 | 19 | |||
16932 | 229274 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1340 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009373.47572 | 2107947.27208 | 37.7685505343184 | -122.41087435478 | (37.7685505343184, -122.41087435478) | 8 | 4 | 7 | 28853 | 19 | |||
17083 | 66960 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1049 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1992 12:00:00 AM | 5 | Permit Number 30297 | 6010166.58935 | 2111603.96693 | 37.7786354094288 | -122.408388988373 | (37.7786354094288, -122.408388988373) | 14 | 2 | 9 | 28853 | 34 | |
17140 | 82928 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1140 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | Permit Number 775675 | 6010008.1126 | 2110668.219 | 37.776057189012 | -122.408871185552 | (37.776057189012, -122.408871185552) | 8 | 2 | 9 | 28853 | 34 | |
18489 | 70673 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 32-34 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6009696.99241 | 2110873.64198 | 37.7766038004599 | -122.409961942206 | (37.7766038004599, -122.409961942206) | 8 | 2 | 9 | 28853 | 34 | |||
20419 | 85704 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 938 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010866.4915 | 2112368.00991 | 37.7807724621315 | -122.406021584247 | (37.7807724621315, -122.406021584247) | 14 | 2 | 9 | 28853 | 34 | ||
20645 | 28147 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 221 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2008 12:00:00 AM | 3 | 3X3 | 6004886.4359084 | 2107088.7371383 | 37.7659405821883 | -122.426333522982 | (37.7659405821883, -122.426333522982) | 8 | 4 | 5 | 28853 | 19 | ||
20772 | 29051 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 298 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2011 12:00:00 AM | 3 | 3x3 | 6008408.15314 | 2109193.10509 | 37.7719171248036 | -122.414301493932 | (37.7719171248036, -122.414301493932) | 8 | 2 | 9 | 28853 | 19 | ||
21323 | 85705 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 938 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010851.34827 | 2112352.58315 | 37.780729256891 | -122.406072885158 | (37.780729256891, -122.406072885158) | 14 | 2 | 9 | 28853 | 34 | ||
23026 | 98687 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 360 10th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 48713 | 6009130 | 2109185 | 37.7719353919897 | -122.411803990978 | (37.7719353919897, -122.411803990978) | 8 | 2 | 9 | 28853 | 34 | ||
23184 | 31089 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 83 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/01/2013 12:00:00 AM | 0 | 3x3 | Permit Number 770108 | 6007730.88694 | 2107505.23533 | 37.7672445640246 | -122.41652463063 | (37.7672445640246, -122.41652463063) | 8 | 4 | 7 | 28853 | 19 |
23649 | 85851 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1630X Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6007563.871097 | 2108998.262092 | 37.771334669982 | -122.417208125188 | (37.771334669982, -122.417208125188) | 8 | 2 | 9 | 28853 | 19 | ||
23756 | 192946 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 251 11th St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6008468.79915 | 2109228.50432 | 37.7720177292585 | -122.414094219087 | (37.7720177292585, -122.414094219087) | 8 | 2 | 9 | 28853 | 34 | |||
24030 | 848 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 109X POTRERO AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2006 12:00:00 AM | 3x3 | Permit Number 777000 | 6010279 | 2107809 | 37.7682216042911 | -122.407732456911 | (37.7682216042911, -122.407732456911) | 8 | 4 | 8 | 28853 | 19 | ||
24061 | 193245 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 857 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011458.89887 | 2112842.39585 | 37.7821081307177 | -122.404005542516 | (37.7821081307177, -122.404005542516) | 6 | 2 | 9 | 28853 | 34 |
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) );