trees
1,985 rows where qSpecies_id = 83 sorted by Zip Codes descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10498 | 41462 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 454 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | Permit Number 42047 | 5993018.04440435 | 2090196.48136289 | 37.7188806981616 | -122.466155833772 | (37.7188806981616, -122.466155833772) | 9 | 8 | 6 | 64 | 24 | |||
32099 | 41461 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 460 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | Permit Number 42046 | 5993018.50469486 | 2090233.49581681 | 37.7189823574514 | -122.466156931137 | (37.7189823574514, -122.466156931137) | 9 | 8 | 6 | 64 | 24 | |||
39382 | 114391 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 23x PINTO AVE | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 5988521 | 2090808 | 37.7202992922588 | -122.481744923362 | (37.7202992922588, -122.481744923362) | 1 | 8 | 4 | 64 | 14 | ||||
78664 | 114390 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 23x PINTO AVE | 1 | Front Yard : Yard | Tree | Private 2 | 7 | 5988521 | 2090808 | 37.7202992922588 | -122.481744923362 | (37.7202992922588, -122.481744923362) | 1 | 8 | 4 | 64 | 14 | ||||
93807 | 31159 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 159 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34861 | 5992168.57477518 | 2088923.19870563 | 37.7153355266741 | -122.46899947505 | (37.7153355266741, -122.46899947505) | 9 | 8 | 6 | 64 | 24 | ||
132540 | 87073 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 395 Byxbee St | 4 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
134671 | 87072 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 395 Byxbee St | 3 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
141906 | 114383 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 418X SERRANO DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
149159 | 86713 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 938 Garfield St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2007 12:00:00 AM | Permit Number 49699 | 5991527 | 2090568.7 | 37.7198165808065 | -122.471336842251 | (37.7198165808065, -122.471336842251) | 9 | 8 | 6 | 64 | 24 | ||||
152541 | 114384 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 418X SERRANO DR | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
11605 | 213995 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 146 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1993 12:00:00 AM | 6 | Width 3ft | Permit Number 32783 | 5999776.55649 | 2094090.41195 | 37.729960150431 | -122.443073900754 | (37.729960150431, -122.443073900754) | 9 | 7 | 4 | 63 | 40 | |
11682 | 89044 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 44 Surrey St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51783 | 6002618 | 2096049 | 37.7354995892493 | -122.433390603486 | (37.7354995892493, -122.433390603486) | 2 | 7 | 5 | 63 | 7 | ||||
14031 | 213996 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 146 Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999758.63525 | 2094089.70358 | 37.7299571835696 | -122.443135805584 | (37.7299571835696, -122.443135805584) | 9 | 7 | 4 | 63 | 40 | |||
14546 | 63665 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3975 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24314 | 6004068.8441765 | 2100399.56050654 | 37.7475274359015 | -122.428684519984 | (37.7475274359015, -122.428684519984) | 2 | 4 | 5 | 63 | 22 | ||
16016 | 5120 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2725 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2016 10:06:00 AM | 3 | 5X5 | 6002461.05615 | 2096042.42458 | 37.7354726294434 | -122.433932747209 | (37.7354726294434, -122.433932747209) | 2 | 7 | 5 | 63 | 7 | ||
16496 | 60642 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20270 | 6004901.36876785 | 2097539.55337894 | 37.7397215914528 | -122.425602180558 | (37.7397215914528, -122.425602180558) | 2 | 7 | 5 | 63 | 7 | ||
20763 | 59417 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 44 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25158 | 6004255.489826 | 2098009.09356154 | 37.7409743251647 | -122.427868803942 | (37.7409743251647, -122.427868803942) | 2 | 7 | 5 | 63 | 7 | ||
21724 | 239356 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 111 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6005135.00311 | 2098711.3374 | 37.7429522432585 | -122.424877716331 | (37.7429522432585, -122.424877716331) | 2 | 7 | 5 | 63 | 22 | |||
23539 | 61014 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 55 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1983 12:00:00 AM | Permit Number 20830 | 6002575.62506459 | 2096039.73920056 | 37.7354717570522 | -122.433536447887 | (37.7354717570522, -122.433536447887) | 2 | 7 | 5 | 63 | 7 | ||
27068 | 240206 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 81 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003903.54766 | 2097252.33034 | 37.7388765103369 | -122.429031747817 | (37.7388765103369, -122.429031747817) | 2 | 7 | 5 | 63 | 7 | |||
32287 | 240137 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 466 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6003486.65901 | 2100127.76337 | 37.7467481782042 | -122.430678286872 | (37.7467481782042, -122.430678286872) | 2 | 7 | 5 | 63 | 22 | |||
35647 | 34349 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 406 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51609 | 6004013.55416632 | 2096149.85411864 | 37.7358555876111 | -122.428572831878 | (37.7358555876111, -122.428572831878) | 2 | 7 | 5 | 63 | 7 | ||
38398 | 26478 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 120 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/2009 12:00:00 AM | 3 | 3X3 | 6001175.6711954 | 2098684.4538551 | 37.7426539948984 | -122.438566040387 | (37.7426539948984, -122.438566040387) | 2 | 7 | 5 | 63 | 7 | ||
39738 | 239351 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 530 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003095.45527 | 2098933.62242 | 37.7434471743571 | -122.431945775202 | (37.7434471743571, -122.431945775202) | 2 | 7 | 5 | 63 | 22 | |||
40358 | 239360 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1301 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6003913.69662 | 2100667.88359 | 37.7482554068595 | -122.429240140544 | (37.7482554068595, -122.429240140544) | 2 | 4 | 5 | 63 | 22 | |||
40402 | 213992 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6001188.39506 | 2095218.69175 | 37.7331385451977 | -122.438273813388 | (37.7331385451977, -122.438273813388) | 9 | 7 | 5 | 63 | 40 | |||
44287 | 240138 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 470 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003459.77034 | 2100123.18676 | 37.7467340885186 | -122.430770938652 | (37.7467340885186, -122.430770938652) | 2 | 7 | 5 | 63 | 22 | |||
45127 | 4223 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3975 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004059.37365 | 2100401.32602 | 37.7475317476004 | -122.428717394312 | (37.7475317476004, -122.428717394312) | 2 | 4 | 5 | 63 | 22 | |||
46695 | 240141 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 401 27th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003855.31232 | 2100097.24015 | 37.7466852472244 | -122.429401344003 | (37.7466852472244, -122.429401344003) | 2 | 7 | 5 | 63 | 22 | |||
46778 | 61001 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2725 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1983 12:00:00 AM | Permit Number 20814 | 6002393.98738915 | 2096184.72110879 | 37.7358595366597 | -122.434174798209 | (37.7358595366597, -122.434174798209) | 2 | 7 | 5 | 63 | 7 | ||
46924 | 240190 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 45 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004298.57929 | 2097992.82616 | 37.7409320961319 | -122.427718657607 | (37.7409320961319, -122.427718657607) | 2 | 7 | 5 | 63 | 7 | |||
48047 | 240196 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 406 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004000.46579 | 2096134.03404 | 37.7358114085533 | -122.42861695621 | (37.7358114085533, -122.42861695621) | 2 | 7 | 5 | 63 | 7 | |||
52352 | 240198 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 46 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002599.46299 | 2096074.44073 | 37.7355683919716 | -122.433456510332 | (37.7355683919716, -122.433456510332) | 2 | 7 | 5 | 63 | 7 | |||
56143 | 239347 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 527 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6003128.43472 | 2098886.31137 | 37.7433191387728 | -122.431828363289 | (37.7433191387728, -122.431828363289) | 2 | 7 | 5 | 63 | 22 | |||
60779 | 60128 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 415 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1982 12:00:00 AM | Permit Number 19656 | 6003855.48725366 | 2096277.36434342 | 37.736196755139 | -122.429128420374 | (37.736196755139, -122.429128420374) | 2 | 7 | 5 | 63 | 7 | ||
63118 | 240202 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3006 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002850.86093 | 2096098.0434 | 37.7356474594489 | -122.432589017977 | (37.7356474594489, -122.432589017977) | 2 | 7 | 5 | 63 | 7 | |||
64935 | 240191 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 31 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004293.70696 | 2098089.97952 | 37.7411985814464 | -122.427742424874 | (37.7411985814464, -122.427742424874) | 2 | 7 | 5 | 63 | 7 | |||
65748 | 4337 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 906 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2001 12:00:00 AM | 6 | 3X3 | 6001499.18849 | 2095960.05903 | 37.7351918404399 | -122.437252384095 | (37.7351918404399, -122.437252384095) | 2 | 7 | 5 | 63 | 7 | ||
66298 | 240207 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 71 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003881.31618 | 2097271.66945 | 37.738928352668 | -122.429109992458 | (37.738928352668, -122.429109992458) | 2 | 7 | 5 | 63 | 7 | |||
67571 | 60613 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 106 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20237 | 6004863.02785957 | 2097589.48802411 | 37.7398565341458 | -122.425738300436 | (37.7398565341458, -122.425738300436) | 2 | 7 | 5 | 63 | 7 | ||
68537 | 239363 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3995 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003937.45795 | 2100690.36733 | 37.7483184871149 | -122.429159577477 | (37.7483184871149, -122.429159577477) | 2 | 4 | 5 | 63 | 22 | |||
68572 | 24482 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 103X Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002240.5138934 | 2096668.0977393 | 37.7371780656004 | -122.434739971035 | (37.7371780656004, -122.434739971035) | 2 | 7 | 5 | 63 | 7 | |||
69731 | 239361 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1400 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003885.73677 | 2100085.59963 | 37.7466550075295 | -122.429295309437 | (37.7466550075295, -122.429295309437) | 2 | 7 | 5 | 63 | 22 | |||
71665 | 240188 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 73 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004313.76435 | 2097764.66953 | 37.7403064890593 | -122.427649901715 | (37.7403064890593, -122.427649901715) | 2 | 7 | 5 | 63 | 7 | |||
71763 | 240204 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 157 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002560.27633 | 2096896.15431 | 37.7378224050816 | -122.433650701839 | (37.7378224050816, -122.433650701839) | 2 | 7 | 5 | 63 | 7 | |||
76064 | 4354 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 15X Burnside Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2008 12:00:00 AM | 3 | 3X3 | 6001141.00413 | 2095696.99513 | 37.7344491599181 | -122.438471913289 | (37.7344491599181, -122.438471913289) | 9 | 7 | 5 | 63 | 7 | ||
76635 | 95398 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1436 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767272 | 6003848 | 2099901 | 37.7461460032944 | -122.429412637248 | (37.7461460032944, -122.429412637248) | 2 | 7 | 5 | 63 | 22 | |
81346 | 64332 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 49 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25160 | 6004309.77102344 | 2097969.94151847 | 37.7408698932086 | -122.427678330625 | (37.7408698932086, -122.427678330625) | 2 | 7 | 5 | 63 | 7 | ||
83870 | 239355 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 117 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6005097.05649 | 2098708.26857 | 37.7429416735155 | -122.425008707103 | (37.7429416735155, -122.425008707103) | 2 | 7 | 5 | 63 | 22 | |||
86813 | 104872 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1753 Noe St | 1 | Hanging basket : Yard | Tree | Private 2 | 11/22/2013 12:00:00 AM | Permit Number 770054 | 6003434.1 | 2098036.1 | 37.7410019772539 | -122.430710793678 | (37.7410019772539, -122.430710793678) | 2 | 7 | 5 | 63 | 7 | |||
87382 | 16010 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100X Monterey Blvd | 4 | Median : Cutout | Tree | DPW 1 | 2 | 4 | 6001411.9312264 | 2094682.0759854 | 37.7316778334432 | -122.437462576871 | (37.7316778334432, -122.437462576871) | 9 | 7 | 4 | 63 | 40 | |||
90947 | 4339 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 901 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/2016 07:58:00 AM | 3 | 3X3 | 6001465.64316 | 2095917.88066 | 37.7350741214051 | -122.437365343013 | (37.7350741214051, -122.437365343013) | 2 | 7 | 5 | 63 | 7 | ||
95976 | 60615 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 141 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | 3x3 | Permit Number 20239 | 6004908.29901709 | 2097432.1661827 | 37.7394271221249 | -122.425570577895 | (37.7394271221249, -122.425570577895) | 2 | 7 | 5 | 63 | 7 | |
96066 | 94681 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 284 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53817 | 6001324 | 2096497 | 37.7366561951725 | -122.437896519679 | (37.7366561951725, -122.437896519679) | 2 | 7 | 5 | 63 | 7 | |
96440 | 60618 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 205 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20242 | 6004849.79426998 | 2097209.93187189 | 37.7388136110977 | -122.425757047896 | (37.7388136110977, -122.425757047896) | 2 | 7 | 5 | 63 | 7 | ||
98722 | 22862 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 151 Turquoise Way | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2X2 | 5999932.75509 | 2099167.18309 | 37.7439086722544 | -122.442898328797 | (37.7439086722544, -122.442898328797) | 2 | 7 | 5 | 63 | 22 | |||
99615 | 60629 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 461 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20255 | 6003690.91133261 | 2096147.61954597 | 37.7358311876742 | -122.429688175872 | (37.7358311876742, -122.429688175872) | 2 | 7 | 5 | 63 | 7 | ||
99683 | 60612 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 76 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | 7 | Permit Number 20236 | 6004870.59253737 | 2097774.41480617 | 37.7403647286117 | -122.425725303892 | (37.7403647286117, -122.425725303892) | 2 | 7 | 5 | 63 | 7 | |
100996 | 239348 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 514 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6003174.42252 | 2098938.53683 | 37.7434651446005 | -122.431673077349 | (37.7434651446005, -122.431673077349) | 2 | 7 | 5 | 63 | 22 | |||
102923 | 43564 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 526 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43225 | 6003158.7675511 | 2098938.54547266 | 37.7434642809487 | -122.431727208875 | (37.7434642809487, -122.431727208875) | 2 | 7 | 5 | 63 | 22 | ||
104634 | 240189 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 49 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004299.90436 | 2097973.73041 | 37.7408797385189 | -122.427712715772 | (37.7408797385189, -122.427712715772) | 2 | 7 | 5 | 63 | 7 | |||
108123 | 68832 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 146 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32783 | 5999773.2281789 | 2094096.14609893 | 37.7299757052964 | -122.443085818741 | (37.7299757052964, -122.443085818741) | 9 | 7 | 4 | 63 | 40 | ||
110187 | 239353 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 333 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003763.45169 | 2098632.19433 | 37.7426573690441 | -122.429614519315 | (37.7426573690441, -122.429614519315) | 2 | 7 | 5 | 63 | 22 | |||
110290 | 239349 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 524 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003127.51447 | 2098934.59686 | 37.7434516673581 | -122.431834992216 | (37.7434516673581, -122.431834992216) | 2 | 7 | 5 | 63 | 22 | |||
110490 | 22817 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 57 Turquoise Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 2X2 | 5999134.8661569 | 2099418.6659098 | 37.7445536617332 | -122.445675315466 | (37.7445536617332, -122.445675315466) | 2 | 7 | 5 | 63 | 22 | ||
111876 | 246509 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 241 Duncan St | 2 | : | Tree | Private 2 | 7 | Width 6ft | 6004948.2324 | 2099866.59265 | 37.7461137586439 | -122.425605722044 | (37.7461137586439, -122.425605722044) | 2 | 7 | 5 | 63 | 22 | |||
112621 | 60621 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 273 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20246 | 6004468.77441112 | 2096758.98359533 | 37.7375538708016 | -122.42704232686 | (37.7375538708016, -122.42704232686) | 2 | 7 | 5 | 63 | 7 | ||
113608 | 4364 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 16X Burnside Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2012 12:00:00 AM | 3 | 3x3 | 6001221.76422 | 2095989.43469 | 37.7352567246132 | -122.438213642387 | (37.7352567246132, -122.438213642387) | 2 | 7 | 5 | 63 | 7 | ||
113716 | 246508 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 241 Duncan St | 1 | : | Tree | Private 2 | 8 | Width 6ft | 6004932.15845 | 2099866.5422 | 37.7461127118493 | -122.425661300149 | (37.7461127118493, -122.425661300149) | 2 | 7 | 5 | 63 | 22 | |||
114958 | 239362 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1400 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003888.14228 | 2100073.30368 | 37.7466213818866 | -122.429286114783 | (37.7466213818866, -122.429286114783) | 2 | 7 | 5 | 63 | 22 | |||
117369 | 32575 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1557 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | 8 | Permit Number 37049 | 6003995.39147 | 2099192.64268 | 37.7442093614769 | -122.428852485076 | (37.7442093614769, -122.428852485076) | 2 | 7 | 5 | 63 | 22 | ||
123043 | 240136 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 277 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004700.17371 | 2100146.19558 | 37.7468674642611 | -122.426483383002 | (37.7468674642611, -122.426483383002) | 2 | 7 | 5 | 63 | 22 | |||
124892 | 240197 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 44 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002619.5193 | 2096053.2786 | 37.7355114234985 | -122.433385656346 | (37.7355114234985, -122.433385656346) | 2 | 7 | 5 | 63 | 7 | |||
125154 | 240205 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 148 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002599.9876 | 2096899.86345 | 37.737834842704 | -122.433513665818 | (37.737834842704, -122.433513665818) | 2 | 7 | 5 | 63 | 7 | |||
125802 | 57690 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 149 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1982 12:00:00 AM | Permit Number 19644 | 6004901.85798659 | 2097408.79404605 | 37.7393625835838 | -122.425591185183 | (37.7393625835838, -122.425591185183) | 2 | 7 | 5 | 63 | 7 | ||
125838 | 43565 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 527 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | 9 | 3x3 | Permit Number 43226 | 6003161.6606046 | 2098886.62601348 | 37.743321886148 | -122.431713499297 | (37.743321886148, -122.431713499297) | 2 | 7 | 5 | 63 | 22 |
126889 | 240195 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1787 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6004009.05897 | 2097810.30767 | 37.7404145605961 | -122.428706704064 | (37.7404145605961, -122.428706704064) | 2 | 7 | 5 | 63 | 7 | |||
129861 | 240200 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 57 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002464.85342 | 2096514.646 | 37.736769456354 | -122.433953362364 | (37.736769456354, -122.433953362364) | 2 | 7 | 5 | 63 | 7 | |||
130778 | 240194 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 48 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004261.63308 | 2097975.00788 | 37.7408810812017 | -122.427845134659 | (37.7408810812017, -122.427845134659) | 2 | 7 | 5 | 63 | 7 | |||
130913 | 43566 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 530 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43227 | 6003134.11486239 | 2098937.17177678 | 37.743459111641 | -122.431812353551 | (37.743459111641, -122.431812353551) | 2 | 7 | 5 | 63 | 22 | ||
130996 | 60626 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 345 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20251 | 6004121.27237368 | 2096486.20510922 | 37.7367852266215 | -122.428224371215 | (37.7367852266215, -122.428224371215) | 2 | 7 | 5 | 63 | 7 | ||
138804 | 65359 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 552 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | 3x3 | Permit Number 28194 | 6003098.7701451 | 2096065.5433654 | 37.7355722775705 | -122.431729581285 | (37.7355722775705, -122.431729581285) | 2 | 7 | 5 | 63 | 7 | |
141110 | 240135 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 277 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004681.7574 | 2100144.35115 | 37.7468613587778 | -122.426546933603 | (37.7468613587778, -122.426546933603) | 2 | 7 | 5 | 63 | 22 | |||
141280 | 240192 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 15 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004287.41019 | 2098213.31975 | 37.7415368893219 | -122.427772982954 | (37.7415368893219, -122.427772982954) | 2 | 7 | 5 | 63 | 7 | |||
144770 | 34399 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 148 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38146 | 6002515.39673717 | 2097007.28397261 | 37.7381249948755 | -122.433813812947 | (37.7381249948755, -122.433813812947) | 2 | 7 | 5 | 63 | 7 | ||
145351 | 239359 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1301 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6003915.03036 | 2100651.96891 | 37.7482117843565 | -122.429234393867 | (37.7482117843565, -122.429234393867) | 2 | 4 | 5 | 63 | 22 | |||
145452 | 240187 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 84 Chenery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004879.89291 | 2097658.89878 | 37.7400480733545 | -122.425684927129 | (37.7400480733545, -122.425684927129) | 2 | 7 | 5 | 63 | 7 | |||
148107 | 240186 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 76 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004876.9244 | 2097755.23098 | 37.7403124119802 | -122.425702045734 | (37.7403124119802, -122.425702045734) | 2 | 7 | 5 | 63 | 7 | |||
150699 | 51026 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 47 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | Permit Number 47503 | 6002619.11600213 | 2095991.78165717 | 37.7353425441161 | -122.433382657578 | (37.7353425441161, -122.433382657578) | 2 | 7 | 5 | 63 | 7 | |||
150701 | 240199 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 48 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002587.38275 | 2096084.89421 | 37.7355964094447 | -122.433499023086 | (37.7355964094447, -122.433499023086) | 2 | 7 | 5 | 63 | 7 | |||
150742 | 4356 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 15X Burnside Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2011 12:00:00 AM | 3 | 5x5 | 6001141.00413 | 2095696.99513 | 37.7344491599181 | -122.438471913289 | (37.7344491599181, -122.438471913289) | 9 | 7 | 5 | 63 | 7 | ||
152435 | 22859 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 199X Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 2X2 | 5999684.0678837 | 2099006.008447 | 37.7434519439013 | -122.443746652137 | (37.7434519439013, -122.443746652137) | 2 | 7 | 5 | 63 | 22 | ||
152457 | 239364 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3995 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003953.0649 | 2100692.52563 | 37.7483252967888 | -122.429105762915 | (37.7483252967888, -122.429105762915) | 2 | 4 | 5 | 63 | 22 | |||
153195 | 4322 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 752 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002136.24288 | 2095781.1252 | 37.7347367232032 | -122.435037065224 | (37.7347367232032, -122.435037065224) | 2 | 7 | 5 | 63 | 7 | |||
155241 | 60628 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 452 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20254 | 6003687.3397941 | 2096211.01990345 | 37.7360050684052 | -122.429705044581 | (37.7360050684052, -122.429705044581) | 2 | 7 | 5 | 63 | 7 | ||
155400 | 5709 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1606 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/1991 12:00:00 AM | 3 | 4X4 | 6005243.99387 | 2098945.2281 | 37.7436006094864 | -122.424517489316 | (37.7436006094864, -122.424517489316) | 2 | 7 | 5 | 63 | 22 | ||
156841 | 240139 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 401 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003806.32516 | 2100095.51377 | 37.7466777333931 | -122.429570613489 | (37.7466777333931, -122.429570613489) | 2 | 7 | 5 | 63 | 22 | |||
157966 | 64315 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 73 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25132 | 6004320.83696842 | 2097772.93842025 | 37.7403295936058 | -122.427626036391 | (37.7403295936058, -122.427626036391) | 2 | 7 | 5 | 63 | 7 | ||
161542 | 63669 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 4051 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24319 | 6003575.7346288 | 2100373.08436005 | 37.7474268185829 | -122.430387772638 | (37.7474268185829, -122.430387772638) | 2 | 4 | 5 | 63 | 22 | ||
162334 | 239354 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 187 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6004748.91753 | 2098687.71701 | 37.7428655719991 | -122.426211013432 | (37.7428655719991, -122.426211013432) | 2 | 7 | 5 | 63 | 22 |
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) );