trees
6,344 rows where qSpecies_id = 19 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 141248 | 10708 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 15 Hillview Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/13/1992 12:00:00 AM | 6 | 3X3 | 6016671.96235 | 2095749.03192 | 37.7354632486319 | -122.384779387057 | (37.7354632486319, -122.384779387057) | 10 | 3 | 8 | 58 | 1 | ||
| 4505 | 59850 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1274 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 4 | Permit Number 19305 | 6016629.87582 | 2093981.66592 | 37.7306080858771 | -122.384801815251 | (37.7306080858771, -122.384801815251) | 10 | 3 | 8 | 58 | 1 | |
| 144584 | 199764 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1255 Thomas Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016594.3244 | 2092538.983 | 37.7266447967684 | -122.384824257677 | (37.7266447967684, -122.384824257677) | 10 | 3 | 8 | 58 | 1 | |||
| 191462 | 47052 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1276 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | 3 | Permit Number 45040 | 6016615.09422 | 2093992.32561 | 37.730636537724 | -122.384853660284 | (37.730636537724, -122.384853660284) | 10 | 3 | 8 | 58 | 1 | |
| 81973 | 199763 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1255 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016578.9006 | 2092551.6525 | 37.7266787316474 | -122.384878459995 | (37.7266787316474, -122.384878459995) | 10 | 3 | 8 | 58 | 1 | |||
| 72594 | 41151 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1255 Thomas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1999 12:00:00 AM | Permit Number 41882 | 6016576.16767017 | 2092557.57832043 | 37.7266948516275 | -122.384888320388 | (37.7266948516275, -122.384888320388) | 10 | 3 | 8 | 58 | 1 | |||
| 102042 | 41150 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1255 Thomas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1999 12:00:00 AM | Permit Number 41882 | 6016576.16767017 | 2092557.57832043 | 37.7266948516275 | -122.384888320388 | (37.7266948516275, -122.384888320388) | 10 | 3 | 8 | 58 | 1 | |||
| 168923 | 41152 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1255 Thomas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1999 12:00:00 AM | Permit Number 41882 | 6016576.16767017 | 2092557.57832043 | 37.7266948516275 | -122.384888320388 | (37.7266948516275, -122.384888320388) | 10 | 3 | 8 | 58 | 1 | |||
| 141815 | 85566 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1276 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016597.9205 | 2094005.77621 | 37.7306725205231 | -122.384913969722 | (37.7306725205231, -122.384913969722) | 10 | 3 | 8 | 58 | 1 | ||
| 27503 | 199762 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1255 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016551.909 | 2092571.4831 | 37.726731689633 | -122.384973150968 | (37.726731689633, -122.384973150968) | 10 | 3 | 8 | 58 | 1 | |||
| 133298 | 38579 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1362 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40539 | 6016531.7201 | 2093711.98 | 37.7298621524902 | -122.385122374239 | (37.7298621524902, -122.385122374239) | 10 | 3 | 8 | 58 | 1 | |
| 166511 | 193312 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1381 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016602.66581 | 2097418.43823 | 37.7400432691891 | -122.385135254204 | (37.7400432691891, -122.385135254204) | 10 | 3 | 8 | 58 | 1 | |||
| 75385 | 193091 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1395 Fairfax Ave | 1 | : | Tree | DPW 1 | 01/27/2015 12:22:00 PM | 6 | Width 3ft | 6016598.40823 | 2097419.67591 | 37.7400464320877 | -122.385150061522 | (37.7400464320877, -122.385150061522) | 10 | 3 | 8 | 58 | 1 | ||
| 167695 | 6806 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1395 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2006 12:00:00 AM | 6 | 3x3 | 6016583.3780675 | 2097443.6071151 | 37.7401113108781 | -122.385203697211 | (37.7401113108781, -122.385203697211) | 10 | 3 | 8 | 58 | 1 | ||
| 171047 | 6811 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1400X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016498.59648 | 2097579.96622 | 37.7404810348687 | -122.385506340556 | (37.7404810348687, -122.385506340556) | 10 | 3 | 8 | 58 | 1 | ||
| 62347 | 38545 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1553 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40517 | 6016422.80620482 | 2093917.0086828 | 37.7304190951777 | -122.385513188555 | (37.7304190951777, -122.385513188555) | 10 | 3 | 8 | 58 | 1 | ||
| 112360 | 38544 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1390x Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 10 | Permit Number 40517 | 6016416.5284 | 2093796.8581 | 37.7300888381629 | -122.385526521894 | (37.7300888381629, -122.385526521894) | 10 | 3 | 8 | 58 | 1 | |
| 77836 | 38542 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1390x Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40517 | 6016397.5824 | 2093808.2257 | 37.7301190030539 | -122.385592813155 | (37.7301190030539, -122.385592813155) | 10 | 3 | 8 | 58 | 1 | |
| 56556 | 6813 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1400X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/15/1998 12:00:00 AM | 6 | 3X3 | 6016463.58165 | 2097607.01609 | 37.7405533709401 | -122.385629294058 | (37.7405533709401, -122.385629294058) | 10 | 3 | 8 | 58 | 1 | ||
| 166419 | 38543 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1390x Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40517 | 6016380.1521 | 2093821.109 | 37.7301534135871 | -122.385653970047 | (37.7301534135871, -122.385653970047) | 10 | 3 | 8 | 58 | 1 | |
| 71145 | 38541 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1543 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 7 | Permit Number 40516 | 6016381.1458 | 2093874.2412 | 37.7302993590512 | -122.385654236285 | (37.7302993590512, -122.385654236285) | 10 | 3 | 8 | 58 | 1 | |
| 137448 | 85572 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1318 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016383.60339 | 2094168.56913 | 37.731107661074 | -122.38566624542 | (37.731107661074, -122.38566624542) | 10 | 3 | 8 | 58 | 1 | ||
| 89019 | 193090 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1401 Fairfax Ave | 3 | : | Tree | Private 2 | 3 | Width 4ft | 6016442.713 | 2097535.30475 | 37.7403553114351 | -122.385696453647 | (37.7403553114351, -122.385696453647) | 10 | 3 | 8 | 58 | 1 | |||
| 147250 | 256029 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1323 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6016352 | 2093043 | 37.7280153225058 | -122.385697085802 | (37.7280153225058, -122.385697085802) | 10 | 3 | 8 | 58 | 1 | ||||
| 122349 | 38546 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1553 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 8 | Permit Number 40517 | 6016366.8237 | 2093859.9191 | 37.7302592409132 | -122.385702752376 | (37.7302592409132, -122.385702752376) | 10 | 3 | 8 | 58 | 1 | |
| 129806 | 193089 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1401 Fairfax Ave | 2 | : | Tree | Private 2 | 3 | Width 4ft | 6016423.24645 | 2097547.7805 | 37.740388490129 | -122.385764631226 | (37.740388490129, -122.385764631226) | 10 | 3 | 8 | 58 | 1 | |||
| 185061 | 85573 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1326 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016350.41282 | 2094192.09476 | 37.7311704211773 | -122.385782631175 | (37.7311704211773, -122.385782631175) | 10 | 3 | 8 | 58 | 1 | ||
| 58018 | 11386 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1435 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/1994 12:00:00 AM | 6 | 3X4 | 6016388.35933 | 2096530.18404 | 37.7375924457244 | -122.385814348454 | (37.7375924457244, -122.385814348454) | 10 | 3 | 8 | 58 | 1 | ||
| 186038 | 8229 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1500X Galvez Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/2016 08:40:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
| 9630 | 248945 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1500x Galvez Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/18/2017 12:00:00 AM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
| 162859 | 193092 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1400 Fairfax Ave | 8 | : | Tree | Private 2 | 3 | Width 3ft | 6016395.45108 | 2097656.02756 | 37.7406841764345 | -122.385868280805 | (37.7406841764345, -122.385868280805) | 10 | 3 | 8 | 58 | 1 | |||
| 158807 | 193093 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1400 Fairfax Ave | 9 | : | Tree | Private 2 | 3 | Width 3ft | 6016378.42726 | 2097668.39024 | 37.7407171797429 | -122.385928004771 | (37.7407171797429, -122.385928004771) | 10 | 3 | 8 | 58 | 1 | |||
| 3434 | 193308 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1500 Galvez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2017 12:00:00 AM | 3 | Width 4ft | 6016349.7682 | 2097340.57346 | 37.7398154754097 | -122.386004251994 | (37.7398154754097, -122.386004251994) | 10 | 3 | 8 | 58 | 1 | ||
| 37013 | 193088 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1445 Fairfax Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6016353.82584 | 2097602.79871 | 37.7405357172446 | -122.386008496795 | (37.7405357172446, -122.386008496795) | 10 | 3 | 8 | 58 | 1 | |||
| 83820 | 85605 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1331X Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016284.219 | 2094162.6734 | 37.7310859728112 | -122.386009426883 | (37.7310859728112, -122.386009426883) | 10 | 3 | 8 | 58 | 1 | ||
| 23487 | 199865 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1600 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6016268.2217 | 2093791.063 | 37.7300647191695 | -122.386038837831 | (37.7300647191695, -122.386038837831) | 10 | 3 | 8 | 58 | 1 | |||
| 73265 | 85574 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1340 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016270.51718 | 2094251.91366 | 37.7313302504855 | -122.386063015505 | (37.7313302504855, -122.386063015505) | 10 | 3 | 8 | 58 | 1 | ||
| 46884 | 199866 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1600 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016259.959 | 2093780.5969 | 37.7300355240413 | -122.386066673972 | (37.7300355240413, -122.386066673972) | 10 | 3 | 8 | 58 | 1 | |||
| 68495 | 83708 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1408 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52294 | 6016257.9441 | 2093910.7968 | 37.7303929155882 | -122.386082712621 | (37.7303929155882, -122.386082712621) | 10 | 3 | 8 | 58 | 1 | |
| 131192 | 199867 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1600 Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6016252.7979 | 2093769.029 | 37.7300033645512 | -122.386090624912 | (37.7300033645512, -122.386090624912) | 10 | 3 | 8 | 58 | 1 | |||
| 174942 | 200083 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1699 Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6016251.1454 | 2093700.7237 | 37.7298157202983 | -122.386091578066 | (37.7298157202983, -122.386091578066) | 10 | 3 | 8 | 58 | 1 | |||
| 14135 | 193309 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1500 Galvez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2017 12:00:00 AM | 3 | Width 4ft | 6016323.77034 | 2097360.91546 | 37.7398698915759 | -122.38609556018 | (37.7398698915759, -122.38609556018) | 10 | 3 | 8 | 58 | 1 | ||
| 136135 | 85606 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1339 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016251.7919 | 2094186.3067 | 37.7311490704717 | -122.386123180923 | (37.7311490704717, -122.386123180923) | 10 | 3 | 8 | 58 | 1 | ||
| 131282 | 200082 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1699 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6016238.4758 | 2093681.9949 | 37.7297635935145 | -122.386134073592 | (37.7297635935145, -122.386134073592) | 10 | 3 | 8 | 58 | 1 | |||
| 115039 | 6823 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1450X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
| 165985 | 6831 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1450X Fairfax Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
| 123081 | 200081 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1699 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016223.6029 | 2093658.3084 | 37.7296977319057 | -122.386183840688 | (37.7296977319057, -122.386183840688) | 10 | 3 | 8 | 58 | 1 | |||
| 89295 | 193094 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1400 Fairfax Ave | 13 | : | Tree | Private 2 | 5 | Width 3ft | 6016292.3394 | 2097733.74624 | 37.7408918694664 | -122.386230221956 | (37.7408918694664, -122.386230221956) | 10 | 3 | 8 | 58 | 1 | |||
| 17007 | 82838 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1415 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6016205.4223 | 2093876.0516 | 37.7302946051933 | -122.386261868118 | (37.7302946051933, -122.386261868118) | 10 | 3 | 8 | 58 | 1 | |||
| 47220 | 85575 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1354 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016198.73439 | 2094304.25494 | 37.7314699961365 | -122.386314831963 | (37.7314699961365, -122.386314831963) | 10 | 3 | 8 | 58 | 1 | ||
| 15790 | 193310 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1500 Galvez Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6016258.92909 | 2097409.86162 | 37.740000698884 | -122.386323167782 | (37.740000698884, -122.386323167782) | 10 | 3 | 8 | 58 | 1 | |||
| 52363 | 40040 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1358 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | Permit Number 41277 | 6016192.43464744 | 2094305.95322391 | 37.7314743105785 | -122.386336729935 | (37.7314743105785, -122.386336729935) | 10 | 3 | 8 | 58 | 1 | ||
| 90749 | 193095 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1498 Fairfax Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6016258.30057 | 2097758.8859 | 37.7409590137548 | -122.386349669012 | (37.7409590137548, -122.386349669012) | 10 | 3 | 8 | 58 | 1 | |||
| 10130 | 193311 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1433 Galvez Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6016240.13881 | 2097427.00946 | 37.7400467432612 | -122.386389332697 | (37.7400467432612, -122.386389332697) | 10 | 3 | 8 | 58 | 1 | |||
| 115119 | 193096 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1498 Fairfax Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6016240.24501 | 2097771.68412 | 37.7409931556099 | -122.386412991184 | (37.7409931556099, -122.386412991184) | 10 | 3 | 8 | 58 | 1 | |||
| 82593 | 85576 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1362 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016164.10041 | 2094332.07658 | 37.731544471681 | -122.386436508451 | (37.731544471681, -122.386436508451) | 10 | 3 | 8 | 58 | 1 | ||
| 146880 | 108320 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1350X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 4x4 | 6016167.8945 | 2094775.3402 | 37.7327617950718 | -122.386454286437 | (37.7327617950718, -122.386454286437) | 10 | 3 | 8 | 58 | 1 | |||
| 126411 | 14995 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1461X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6016220.8141 | 2097701.01235 | 37.7407980297092 | -122.386475250338 | (37.7407980297092, -122.386475250338) | 10 | 3 | 8 | 58 | 1 | |||
| 176165 | 46626 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1419 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 3 | Permit Number 44748 | 6016156.5919 | 2094962.4616 | 37.7332749673051 | -122.386506405457 | (37.7332749673051, -122.386506405457) | 10 | 3 | 8 | 58 | 1 | |
| 3633 | 46628 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1426 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 0 | Permit Number 44749 | 6016155.81653285 | 2095029.68224774 | 37.7334594988152 | -122.386513771605 | (37.7334594988152, -122.386513771605) | 10 | 3 | 8 | 58 | 1 | |
| 102079 | 192997 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1856 Illinois St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 6ft | 6016261.5851 | 2100510.3314 | 37.748514099551 | -122.386530117095 | (37.748514099551, -122.386530117095) | 10 | 3 | 8 | 58 | 1 | |||
| 178356 | 193097 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1498 Fairfax Ave | 5 | : | Tree | Private 2 | 3 | Width 3ft | 6016206.41009 | 2097796.61241 | 37.7410597306212 | -122.38653171878 | (37.7410597306212, -122.38653171878) | 10 | 3 | 8 | 58 | 1 | |||
| 67287 | 40041 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1370 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 4 | Permit Number 41278 | 6016124.54113 | 2094358.4736 | 37.7316147627139 | -122.386575113773 | (37.7316147627139, -122.386575113773) | 10 | 3 | 8 | 58 | 1 | |
| 173610 | 6839 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1475 FAIRFAX AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6016157 | 2097767 | 37.7409756855874 | -122.386700497992 | (37.7409756855874, -122.386700497992) | 10 | 3 | 8 | 58 | 1 | ||
| 4068 | 38625 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1396 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | Permit Number 40563 | 6016053.9414 | 2093366.9092 | 37.7288882156246 | -122.386750071292 | (37.7288882156246, -122.386750071292) | 10 | 3 | 8 | 58 | 1 | |
| 50582 | 6838 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1475 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2001 12:00:00 AM | 5 | 3X3 | 6016138.23461 | 2097761.58271 | 37.7409597718784 | -122.386765004722 | (37.7409597718784, -122.386765004722) | 10 | 3 | 8 | 58 | 1 | ||
| 18043 | 60382 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1388 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 2 | Permit Number 19962 | 6016050.49586 | 2094420.00347 | 37.7317796120287 | -122.38683539465 | (37.7317796120287, -122.38683539465) | 10 | 3 | 8 | 58 | 1 | |
| 119696 | 85579 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1388 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016037.21372 | 2094429.10927 | 37.7318038793275 | -122.386881948958 | (37.7318038793275, -122.386881948958) | 10 | 3 | 8 | 58 | 1 | ||
| 111764 | 40027 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1454 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 5 | Permit Number 41270 | 6016009.0296 | 2095144.5597 | 37.7337668023023 | -122.387029269673 | (37.7337668023023, -122.387029269673) | 10 | 3 | 8 | 58 | 1 | |
| 31443 | 193304 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1502 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016023.1071 | 2096881.43664 | 37.7385366952096 | -122.3871017028 | (37.7385366952096, -122.3871017028) | 10 | 3 | 8 | 58 | 1 | |||
| 10970 | 60364 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1397 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 4 | Permit Number 19942 | 6015971.722 | 2094398.676 | 37.7317166892309 | -122.387106247473 | (37.7317166892309, -122.387106247473) | 10 | 3 | 8 | 58 | 1 | |
| 164863 | 193305 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 818 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6016014.82384 | 2096792.82035 | 37.7382929141733 | -122.387124163353 | (37.7382929141733, -122.387124163353) | 10 | 3 | 8 | 58 | 1 | |||
| 141545 | 83001 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1379 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52369 | 6015908.5172 | 2093052.9252 | 37.7280180254071 | -122.387230924952 | (37.7280180254071, -122.387230924952) | 10 | 3 | 8 | 58 | 1 | |
| 49675 | 22110 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3600X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6015973.48399 | 2098973.66495 | 37.744278778308 | -122.387419191637 | (37.744278778308, -122.387419191637) | 10 | 3 | 8 | 58 | 1 | |||
| 122513 | 22109 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3600X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6015973.48399 | 2098973.66495 | 37.744278778308 | -122.387419191637 | (37.744278778308, -122.387419191637) | 10 | 3 | 8 | 58 | 1 | |||
| 73168 | 38564 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1480 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | Permit Number 40530 | 6015897.2591 | 2095226.8178 | 37.7339864767788 | -122.387421433415 | (37.7339864767788, -122.387421433415) | 10 | 3 | 8 | 58 | 1 | |
| 122032 | 193307 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1499 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015889.27633 | 2096264.97545 | 37.7368366060316 | -122.387521434365 | (37.7368366060316, -122.387521434365) | 10 | 3 | 8 | 58 | 1 | |||
| 15265 | 60385 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1418 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 5 | Permit Number 19965 | 6015851.3994 | 2094564.1651 | 37.7321644254987 | -122.38753377178 | (37.7321644254987, -122.38753377178) | 10 | 3 | 8 | 58 | 1 | |
| 95170 | 193015 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3600 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6015932.14126 | 2098943.65469 | 37.7441940864782 | -122.387560053979 | (37.7441940864782, -122.387560053979) | 10 | 3 | 8 | 58 | 1 | |||
| 69286 | 12876 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1219 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6015860.1932 | 2095406.1711 | 37.7344768918771 | -122.387562091269 | (37.7344768918771, -122.387562091269) | 10 | 3 | 8 | 58 | 1 | |||
| 109960 | 193016 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3600 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6015923.78669 | 2098921.70303 | 37.7441333489873 | -122.387587411336 | (37.7441333489873, -122.387587411336) | 10 | 3 | 8 | 58 | 1 | |||
| 187179 | 22111 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3600X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6015918.81495 | 2098901.50155 | 37.7440776044988 | -122.387603193554 | (37.7440776044988, -122.387603193554) | 10 | 3 | 8 | 58 | 1 | |||
| 84457 | 6667 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Evans Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 01:21:00 PM | 3 | 3X3 | 6015906.32098 | 2098408.37334 | 37.7427228837554 | -122.387611997891 | (37.7427228837554, -122.387611997891) | 10 | 3 | 8 | 58 | 1 | ||
| 50008 | 82714 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1434 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52468 | 6015808.2627 | 2093548.1385 | 37.7293722301295 | -122.387612046257 | (37.7293722301295, -122.387612046257) | 10 | 3 | 8 | 58 | 1 | |
| 130965 | 193017 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3600 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015883.1913 | 2098840.10206 | 37.7439070408843 | -122.387722090214 | (37.7439070408843, -122.387722090214) | 10 | 3 | 8 | 58 | 1 | |||
| 31872 | 193018 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3600 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015871.31513 | 2098824.58498 | 37.743863776308 | -122.38776207318 | (37.743863776308, -122.38776207318) | 10 | 3 | 8 | 58 | 1 | |||
| 32025 | 193019 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3600 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015859.74339 | 2098809.06176 | 37.7438205117227 | -122.387801003014 | (37.7438205117227, -122.387801003014) | 10 | 3 | 8 | 58 | 1 | |||
| 3381 | 258768 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1511 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015807.577 | 2096620.6892 | 37.7378087983482 | -122.38782872013 | (37.7378087983482, -122.38782872013) | 10 | 3 | 8 | 58 | 1 | ||||
| 108781 | 88042 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1511 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51055 | 6015807.577 | 2096620.6892 | 37.7378087983482 | -122.38782872013 | (37.7378087983482, -122.38782872013) | 10 | 3 | 8 | 58 | 1 | |
| 169553 | 193020 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3600 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015850.05142 | 2098796.22761 | 37.7437847348902 | -122.387833620539 | (37.7437847348902, -122.387833620539) | 10 | 3 | 8 | 58 | 1 | |||
| 5221 | 46411 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 525X 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52278 | 6015977.84148898 | 2105815.09709753 | 37.763064153155 | -122.387881407344 | (37.763064153155, -122.387881407344) | 14 | 3 | 8 | 28856 | 29 | |
| 9123 | 46414 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 525X 18th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44641 | 6015977.84148898 | 2105815.09709753 | 37.763064153155 | -122.387881407344 | (37.763064153155, -122.387881407344) | 14 | 3 | 8 | 28856 | 29 | |
| 45784 | 46413 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 525X 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44641 | 6015977.84148898 | 2105815.09709753 | 37.763064153155 | -122.387881407344 | (37.763064153155, -122.387881407344) | 14 | 3 | 8 | 28856 | 29 | |
| 71312 | 46412 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 525X 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44641 | 6015977.84148898 | 2105815.09709753 | 37.763064153155 | -122.387881407344 | (37.763064153155, -122.387881407344) | 14 | 3 | 8 | 28856 | 29 | |
| 117057 | 46410 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 525X 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52278 | 6015977.84148898 | 2105815.09709753 | 37.763064153155 | -122.387881407344 | (37.763064153155, -122.387881407344) | 14 | 3 | 8 | 28856 | 29 | |
| 166394 | 46409 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 525X 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52278 | 6015977.84148898 | 2105815.09709753 | 37.763064153155 | -122.387881407344 | (37.763064153155, -122.387881407344) | 14 | 3 | 8 | 28856 | 29 | |
| 49057 | 193306 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1499 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015779.37833 | 2096310.48205 | 37.7369554703275 | -122.387904577927 | (37.7369554703275, -122.387904577927) | 10 | 3 | 8 | 58 | 1 | |||
| 15059 | 254699 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 778364 | 6015970.50894 | 2106056.61706 | 37.7637269088073 | -122.387923622314 | (37.7637269088073, -122.387923622314) | 14 | 3 | 8 | 28856 | 29 | ||
| 96441 | 254702 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 778364 | 6015970.50894 | 2106056.61706 | 37.7637269088073 | -122.387923622314 | (37.7637269088073, -122.387923622314) | 14 | 3 | 8 | 28856 | 29 | ||
| 145856 | 254700 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 778364 | 6015970.50894 | 2106056.61706 | 37.7637269088073 | -122.387923622314 | (37.7637269088073, -122.387923622314) | 14 | 3 | 8 | 28856 | 29 |
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) );