trees
6,714 rows where qSpecies_id = 7 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
169417 | 22830 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 88 Turquoise Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 5999067.1751904 | 2099480.26243 | 37.7447189259574 | -122.445913805631 | (37.7447189259574, -122.445913805631) | 2 | 7 | 5 | 63 | 7 | |||
171948 | 26 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 736 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/1992 12:00:00 AM | 12 | 3X3 | 6003885.72532 | 2107769.72577 | 37.7677537952191 | -122.4298433527 | (37.7677537952191, -122.4298433527) | 7 | 9 | 5 | 28862 | 3 | ||
172763 | 28653 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1600X Webster St | 15 | Median : Cutout | Tree | DPW 1 | 12 | 6 | 6003605.1476962 | 2114190.7261663 | 37.785368381567 | -122.431272227533 | (37.785368381567, -122.431272227533) | 13 | 9 | 11 | 29490 | 13 | |||
174042 | 12438 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1595X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2005 12:00:00 AM | 3 | 3X3 | 6004488.80475 | 2114299.5475 | 37.785717215657 | -122.428222797765 | (37.785717215657, -122.428222797765) | 13 | 9 | 11 | 29490 | 13 | ||
174779 | 10040 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 360 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005476.56858 | 2106925.65434 | 37.7655261358546 | -122.424280773346 | (37.7655261358546, -122.424280773346) | 8 | 4 | 5 | 28853 | 19 | |||
174929 | 21220 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2392X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
177336 | 214300 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 200x Terrace Dr | 42 | Median : Yard | Tree | DPW 1 | 17 | 5993888.01583 | 2096515.69839 | 37.7362818799091 | -122.463607084997 | (37.7362818799091, -122.463607084997) | 1 | 8 | 4 | 59 | 40 | ||||
178266 | 254328 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 550 Jessie St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6009783.66194 | 2112493.30465 | 37.7810558696866 | -122.409776479401 | (37.7810558696866, -122.409776479401) | 14 | 2 | 9 | 28853 | 34 | |||||
180218 | 5096 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2617 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/08/2005 12:00:00 AM | 15 | 4x7 | 6002321.1773 | 2096442.08451 | 37.7365620645731 | -122.434444926405 | (37.7365620645731, -122.434444926405) | 2 | 7 | 5 | 63 | 7 | ||
181918 | 1917 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 12 Bell Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6016599.62723 | 2095217.01267 | 37.7339984292864 | -122.384992424754 | (37.7339984292864, -122.384992424754) | 10 | 3 | 8 | 58 | 1 | |||
182267 | 16823 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2139X O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6001040.8337 | 2113118.4303 | 37.7822784765294 | -122.440067043321 | (37.7822784765294, -122.440067043321) | 15 | 5 | 11 | 29490 | 41 | |||
182773 | 26668 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 102 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 6005390.51366 | 2108390.09444 | 37.7695422787685 | -122.424682603942 | (37.7695422787685, -122.424682603942) | 8 | 4 | 5 | 28853 | 19 | |||
183404 | 8201 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1360 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6001243.6294 | 2111120.8056 | 37.7768050488635 | -122.439222237812 | (37.7768050488635, -122.439222237812) | 15 | 5 | 11 | 29492 | 41 | |||
183849 | 28652 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1600X Webster St | 14 | Median : Cutout | Tree | DPW 1 | 20 | 6 | 6003605.1476962 | 2114190.7261663 | 37.785368381567 | -122.431272227533 | (37.785368381567, -122.431272227533) | 13 | 9 | 11 | 29490 | 13 | |||
184294 | 19025 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3170 Sacramento St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 8 | 2X2 | 5999621.13212 | 2115414.43387 | 37.7885017807754 | -122.445143681435 | (37.7885017807754, -122.445143681435) | 13 | 6 | 1 | 29490 | 27 | |||
186488 | 4450 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1368 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6004484.29512 | 2100913.96053 | 37.748963363065 | -122.427284553034 | (37.748963363065, -122.427284553034) | 2 | 4 | 5 | 28862 | 22 | |||
187280 | 11411 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1482 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/10/1992 12:00:00 AM | 6 | 3X4 | 6016167.73514 | 2096777.35021 | 37.738258902726 | -122.386594388046 | (37.738258902726, -122.386594388046) | 10 | 3 | 8 | 58 | 1 | ||
190233 | 138187 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1865 Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/1998 12:00:00 AM | 6 | Width 0ft | 6003949.1621 | 2114685.5907 | 37.7867466447295 | -122.430117356836 | (37.7867466447295, -122.430117356836) | 13 | 9 | 11 | 29490 | 27 | ||
193035 | 26124 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1439 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015892.5497 | 2094809.562 | 37.7328405153421 | -122.387408617446 | (37.7328405153421, -122.387408617446) | 10 | 3 | 8 | 58 | 1 | |||
193072 | 10119 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 850 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/06/1992 12:00:00 AM | 18 | 3X3 | 6005631.880167 | 2104012.3184419 | 37.757535570368 | -122.423536442741 | (37.757535570368, -122.423536442741) | 2 | 4 | 5 | 28859 | 19 | ||
193851 | 4405 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1050 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/01/1993 12:00:00 AM | 12 | 3X3 | 6004381.0178 | 2102775.98302 | 37.7540702011025 | -122.427774340913 | (37.7540702011025, -122.427774340913) | 2 | 4 | 5 | 28862 | 22 | ||
194159 | 10077 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 611 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005621.78486 | 2105416.82041 | 37.7613914334809 | -122.423671214664 | (37.7613914334809, -122.423671214664) | 2 | 4 | 5 | 28859 | 19 | |||
194310 | 264995 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993564.21584 | 2106614.23574 | 37.7639912206449 | -122.465459964506 | (37.7639912206449, -122.465459964506) | 1 | 8 | 11 | 56 | 12 | |
194314 | 214535 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993564.21584 | 2106614.23574 | 37.7639912206449 | -122.465459964506 | (37.7639912206449, -122.465459964506) | 1 | 8 | 11 | 56 | 12 | |
194317 | 264994 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993564.21584 | 2106614.23574 | 37.7639912206449 | -122.465459964506 | (37.7639912206449, -122.465459964506) | 1 | 8 | 11 | 56 | 12 | |
9 | 32966 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 556 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/2020 12:00:00 AM | 3 | Permit Number 37281 | 6014072.59224 | 2104507.52941 | 37.759368126158 | -122.394379509632 | (37.759368126158, -122.394379509632) | 10 | 3 | 8 | 28856 | 29 | |
72 | 135801 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 16 Phoenix Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6008610.92916 | 2117913.61927 | 37.7958729471262 | -122.414217164494 | (37.7958729471262, -122.414217164494) | 5 | 1 | 10 | 308 | 21 | |||
95 | 261359 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007238 | 2095678 | 37.7347419306018 | -122.417391193891 | (37.7347419306018, -122.417391193891) | 2 | 7 | 7 | 28859 | 2 | ||||
97 | 261358 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2x Bache St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2095707 | 37.7348180134015 | -122.417611061749 | (37.7348180134015, -122.417611061749) | 2 | 7 | 7 | 28859 | 2 | ||||
152 | 235666 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Jessie St | 4 | : | Tree | Private 2 | 3 | Width 2ft | 6006462.25734 | 2109005.38337 | 37.7712921868165 | -122.421019169707 | (37.7712921868165, -122.421019169707) | 8 | 2 | 9 | 28853 | 19 | |||
189 | 178694 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 184 Mount Vernon Ave | 7 | Side Yard : Yard | Tree | Private 2 | 9 | 5998957.82756 | 2089383.479 | 37.7169892861082 | -122.445565994978 | (37.7169892861082, -122.445565994978) | 9 | 7 | 6 | 28861 | 25 | ||||
199 | 237529 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1197 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003874.24561 | 2101347.66783 | 37.7501197023675 | -122.429425031242 | (37.7501197023675, -122.429425031242) | 2 | 4 | 5 | 28862 | 22 | |||
211 | 196303 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 249 Shipley St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011469.59111 | 2111688.37468 | 37.7789400547713 | -122.403887319468 | (37.7789400547713, -122.403887319468) | 14 | 2 | 9 | 28856 | 34 | |||
259 | 196282 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 13 | : Yard | Tree | Private 2 | 12 | 6015015.25562 | 2102205.64875 | 37.7531000097757 | -122.390958410295 | (37.7531000097757, -122.390958410295) | 10 | 3 | 8 | 28856 | 29 | ||||
312 | 201949 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 18 | : | Tree | Private 2 | 2 | Width 3ft | 6013468.57071 | 2092447.06427 | 37.7262190300648 | -122.395623522912 | (37.7262190300648, -122.395623522912) | 10 | 3 | 8 | 58 | 1 | |||
332 | 182987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1975 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5989890.895 | 2098325.8493 | 37.7410209633467 | -122.477558903564 | (37.7410209633467, -122.477558903564) | 1 | 8 | 3 | 29491 | 35 | |||
389 | 121965 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 15th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5991180.37033 | 2114963.80683 | 37.7867790889821 | -122.474314218886 | (37.7867790889821, -122.474314218886) | 11 | 6 | 1 | 54 | 33 | ||||
437 | 202267 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 28 Orsi Cir | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6013033.98272 | 2093207.99375 | 37.7282842035544 | -122.397179214247 | (37.7282842035544, -122.397179214247) | 10 | 3 | 8 | 58 | 1 | |||
491 | 246210 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 725 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2019 12:00:00 AM | 3 | Width 0ft | 5999854.0817 | 2107930.8602 | 37.7679670970626 | -122.443799851593 | (37.7679670970626, -122.443799851593) | 15 | 5 | 11 | 29492 | 9 | ||
518 | 70144 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 8 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5991175.64413 | 2115000.10527 | 37.7868784805694 | -122.474333220033 | (37.7868784805694, -122.474333220033) | 11 | 6 | 1 | 54 | 33 | |||
560 | 97763 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2011 12:00:00 AM | 1 | Permit Number 768298 | 5996511.5635 | 2113681.1555 | 37.783564683267 | -122.455776900676 | (37.783564683267, -122.455776900676) | 11 | 6 | 1 | 54 | 31 | ||
587 | 37078 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1318 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 2 | Permit Number 39680 | 5982466.3981 | 2106106.9098 | 37.7619519432804 | -122.50380580728 | (37.7619519432804, -122.50380580728) | 1 | 8 | 3 | 56 | 35 | |
651 | 59344 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 532 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1980 12:00:00 AM | 8 | Permit Number 18692 | 6000155.0247 | 2110781.0357 | 37.7758101209138 | -122.44296363094 | (37.7758101209138, -122.44296363094) | 15 | 5 | 11 | 29492 | 16 | |
681 | 71797 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2033 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5998131.4502 | 2109940.9744 | 37.7733879494567 | -122.449903100064 | (37.7733879494567, -122.449903100064) | 15 | 5 | 11 | 29492 | 16 | |||
726 | 213079 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 127 Castenada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994523.12061 | 2101041.16824 | 37.7487442639422 | -122.461739308234 | (37.7487442639422, -122.461739308234) | 1 | 8 | 4 | 29491 | 40 | |||
752 | 32695 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1106 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 5 | 3x3 | Permit Number 37103 | 6008138.63139 | 2115547.98028 | 37.7893509440283 | -122.415683826556 | (37.7893509440283, -122.415683826556) | 13 | 1 | 10 | 28858 | 21 |
816 | 248050 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 38 Rutledge St | 7 | Side Yard : Yard | Tree | Private 2 | 5 | 6010496.13368 | 2099436.61391 | 37.7452450531093 | -122.406391405264 | (37.7452450531093, -122.406391405264) | 2 | 7 | 7 | 28859 | 2 | ||||
839 | 71209 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2170 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988552.6315 | 2100561.3439 | 37.7470812936995 | -122.48234982645 | (37.7470812936995, -122.48234982645) | 1 | 8 | 3 | 29491 | 35 | |||
902 | 213099 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 48 Brentwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996420.67751 | 2095562.94637 | 37.733811460225 | -122.454781859719 | (37.733811460225, -122.454781859719) | 9 | 7 | 4 | 59 | 40 | |||
967 | 78568 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1192 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009666.22083 | 2090670.9365 | 37.7211299140849 | -122.408642858878 | (37.7211299140849, -122.408642858878) | 9 | 3 | 7 | 309 | 28 | |||
994 | 236914 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 341 Moultrie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007736.81458 | 2097491.93265 | 37.7397506441775 | -122.415795016921 | (37.7397506441775, -122.415795016921) | 2 | 7 | 7 | 28859 | 2 | |||
996 | 70145 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 32 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5991181.63526 | 2114912.21638 | 37.7866375092707 | -122.474306076539 | (37.7866375092707, -122.474306076539) | 11 | 6 | 1 | 54 | 33 | |||
1000 | 52636 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 185@ BELMONT Edgewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48718 | 5996563.25999555 | 2105933.66378054 | 37.7622950546263 | -122.455038038603 | (37.7622950546263, -122.455038038603) | 15 | 5 | 11 | 29492 | 12 | ||||
1074 | 80599 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 888 Tennessee St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015456.30873 | 2104984.78613 | 37.7607553924711 | -122.389627233831 | (37.7607553924711, -122.389627233831) | 10 | 3 | 8 | 28856 | 29 | |||
1128 | 178845 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 543 Sawyer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007634.8415 | 2086934.39681 | 37.7107561785306 | -122.415400376427 | (37.7107561785306, -122.415400376427) | 9 | 7 | 8 | 309 | 39 | |||
1159 | 70451 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2683 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5983041.4986 | 2096885.6865 | 37.7366668238827 | -122.5011347377 | (37.7366668238827, -122.5011347377) | 1 | 8 | 3 | 29491 | 35 | |||
1207 | 39056 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2800X 18th St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009422.123 | 2105494.394 | 37.7618182216771 | -122.410532856099 | (37.7618182216771, -122.410532856099) | 8 | 4 | 7 | 28859 | 19 | ||
1235 | 54485 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 524 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/1972 12:00:00 AM | 3 | Permit Number 10277 | 5983807.43995 | 2112211.38308 | 37.7787918392432 | -122.499618921418 | (37.7787918392432, -122.499618921418) | 11 | 6 | 2 | 55 | 26 | |
1236 | 78452 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3075 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5989337.22841 | 2094863.71499 | 37.7314826909771 | -122.479220054956 | (37.7314826909771, -122.479220054956) | 1 | 8 | 4 | 64 | 35 | |||
1243 | 237775 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 51 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001962.65396 | 2106203.64248 | 37.763344625173 | -122.43638291504 | (37.763344625173, -122.43638291504) | 15 | 5 | 5 | 28862 | 3 | |||
1251 | 218033 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 70 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993104.01352 | 2098691.4194 | 37.7422106578044 | -122.466475770336 | (37.7422106578044, -122.466475770336) | 1 | 8 | 4 | 59 | 40 | |||
1276 | 72277 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 819 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5983524.1138 | 2110218.5518 | 37.7733034736496 | -122.500451657892 | (37.7733034736496, -122.500451657892) | 11 | 6 | 2 | 55 | 26 | |||
1429 | 237519 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 155 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004137.76382 | 2100992.35213 | 37.7491590042859 | -122.428488446692 | (37.7491590042859, -122.428488446692) | 2 | 4 | 5 | 28862 | 22 | |||
1470 | 261195 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 600X Benton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007231 | 2095349 | 37.7338381748563 | -122.417392087376 | (37.7338381748563, -122.417392087376) | 2 | 7 | 7 | 28859 | 2 | ||||
1471 | 68309 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 273 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 5 | Permit Number 32120 | 5990851.78966 | 2113569.99779 | 37.7829330362374 | -122.47534921912 | (37.7829330362374, -122.47534921912) | 11 | 6 | 2 | 54 | 26 | |
1515 | 31846 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
1550 | 201970 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 21 | : | Tree | Private 2 | 3 | Width 3ft | 6013765.00423 | 2092206.62002 | 37.7255753034535 | -122.39458193082 | (37.7255753034535, -122.39458193082) | 10 | 3 | 8 | 58 | 1 | |||
1563 | 83933 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1858 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51018 | 6000198.5471 | 2111317.0904 | 37.7772844720096 | -122.442851578579 | (37.7772844720096, -122.442851578579) | 15 | 5 | 11 | 29490 | 16 | |
1627 | 35149 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 11 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38681 | 6004664.75137838 | 2109286.2995173 | 37.7719620248453 | -122.427256837171 | (37.7719620248453, -122.427256837171) | 7 | 9 | 11 | 28852 | 10 | ||
1756 | 217968 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2535 17th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991076.46377 | 2098128.02027 | 37.74054650193 | -122.473445254517 | (37.74054650193, -122.473445254517) | 1 | 8 | 4 | 29491 | 40 | |||
1775 | 196240 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 477 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010588.30864 | 2112340.27099 | 37.7806807348789 | -122.406982002622 | (37.7806807348789, -122.406982002622) | 14 | 2 | 9 | 28853 | 34 | |||
1789 | 39904 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2807 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2001 12:00:00 AM | 6 | Permit Number 44042 | 6001235.05057 | 2115912.0484 | 37.7899600881353 | -122.439595474174 | (37.7899600881353, -122.439595474174) | 13 | 6 | 1 | 29490 | 27 | |
1797 | 72003 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1991 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987539.672 | 2101751.7111 | 37.7502907477313 | -122.485939871711 | (37.7502907477313, -122.485939871711) | 1 | 8 | 3 | 29491 | 35 | |||
1801 | 73988 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3380 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5998684.41396 | 2115276.24554 | 37.7880688417562 | -122.448374611919 | (37.7880688417562, -122.448374611919) | 13 | 6 | 1 | 54 | 31 | |||
1814 | 43257 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 400 Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43041 | 6010158.39254276 | 2093206.15154528 | 37.7281186387281 | -122.407120168437 | (37.7281186387281, -122.407120168437) | 10 | 3 | 7 | 309 | 28 | ||
1836 | 214279 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 422 Edna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998780.00952 | 2094220.12118 | 37.7302594304325 | -122.446528398166 | (37.7302594304325, -122.446528398166) | 9 | 7 | 4 | 28861 | 40 | |||
1844 | 212645 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 385 Vernon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992447.95571 | 2090426.49221 | 37.7194793442858 | -122.468143110712 | (37.7194793442858, -122.468143110712) | 9 | 8 | 6 | 64 | 24 | |||
1853 | 214288 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 38 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/23/2000 12:00:00 AM | 13 | Width 3ft | Permit Number 42619 | 5999806.95305 | 2093809.09712 | 37.7291894584065 | -122.442948622496 | (37.7291894584065, -122.442948622496) | 9 | 7 | 4 | 63 | 40 | |
1922 | 260512 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 180 Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990850 | 2091280 | 37.7217304489912 | -122.473728831815 | (37.7217304489912, -122.473728831815) | 9 | 8 | 4 | 64 | 40 | ||||
1931 | 213034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 119 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5996575.5142 | 2106308.44603 | 37.7633248140133 | -122.455022738629 | (37.7633248140133, -122.455022738629) | 15 | 5 | 11 | 29492 | 12 | |||
1955 | 55970 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1246 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2017 12:00:00 AM | 3 | Permit Number 12041 | 6008815.91632 | 2116679.99391 | 37.7924972267216 | -122.413420580993 | (37.7924972267216, -122.413420580993) | 5 | 1 | 10 | 28857 | 21 | ||
1971 | 60793 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 300 Ewing Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1983 12:00:00 AM | 7 | Permit Number 20467 | 5998509.2912 | 2112152.7993 | 37.779482661953 | -122.448755442586 | (37.779482661953, -122.448755442586) | 15 | 6 | 2 | 54 | 16 | |
2046 | 72250 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 360 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6002105.68115 | 2091634.84352 | 37.7233502412928 | -122.434846310935 | (37.7233502412928, -122.434846310935) | 9 | 7 | 6 | 28861 | 5 | |||
2068 | 214271 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 519 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997445.19027 | 2095126.33403 | 37.7326713410914 | -122.451208353186 | (37.7326713410914, -122.451208353186) | 9 | 7 | 4 | 59 | 40 | |||
2132 | 235898 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3623 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x5 | 6005449.14976 | 2104867.03319 | 37.7598721008326 | -122.424229185527 | (37.7598721008326, -122.424229185527) | 2 | 4 | 5 | 28859 | 19 | |||
2141 | 70199 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 479-481 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5990281.69585 | 2112130.11385 | 37.7789464534529 | -122.477216227307 | (37.7789464534529, -122.477216227307) | 11 | 6 | 2 | 55 | 26 | |||
2255 | 236751 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 420 Collingwood St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | 6002101.36864 | 2103370.60532 | 37.7555736715096 | -122.435700446513 | (37.7555736715096, -122.435700446513) | 2 | 4 | 5 | 28862 | 22 | ||||
2298 | 248463 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 130 Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5997448.7103 | 2107810.4856 | 37.7674990867904 | -122.452111034778 | (37.7674990867904, -122.452111034778) | 15 | 5 | 11 | 29492 | 9 | |||
2423 | 183529 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2590 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5988341.8215 | 2097699.5391 | 37.7392112662203 | -122.482869079468 | (37.7392112662203, -122.482869079468) | 1 | 8 | 3 | 29491 | 35 | |||
2466 | 68381 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 42 Uranus Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32206 | 5999268.74613245 | 2105519.44927205 | 37.7613125625383 | -122.445651023552 | (37.7613125625383, -122.445651023552) | 15 | 5 | 5 | 28862 | 3 | ||
2482 | 31979 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 246 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 7 | Permit Number 35378 | 5995256.47104 | 2113909.90159 | 37.7841206491804 | -122.460135585049 | (37.7841206491804, -122.460135585049) | 11 | 6 | 2 | 54 | 11 | |
2505 | 196318 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 323 11th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6008553.79261 | 2109149.29537 | 37.7718050135221 | -122.413794615322 | (37.7718050135221, -122.413794615322) | 8 | 2 | 9 | 28853 | 34 | |||
2508 | 40281 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 379 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41433 | 6007237.3550509 | 2105117.81917656 | 37.7606615087743 | -122.418062420589 | (37.7606615087743, -122.418062420589) | 2 | 4 | 7 | 28859 | 19 | ||
2535 | 70599 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 346 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6004344.49924 | 2091141.9903 | 37.7221238322355 | -122.427072045934 | (37.7221238322355, -122.427072045934) | 9 | 7 | 6 | 28861 | 5 | |||
2596 | 70483 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 939 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6005126.74678 | 2092081.98496 | 37.7247490558006 | -122.424434831697 | (37.7247490558006, -122.424434831697) | 9 | 7 | 6 | 28861 | 5 | |||
2634 | 40957 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 735 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 7 | Permit Number 42441 | 5990344.94056 | 2110364.54527 | 37.7741023575346 | -122.476868403223 | (37.7741023575346, -122.476868403223) | 11 | 6 | 2 | 55 | 26 | |
2662 | 51421 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 655 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2004 12:00:00 AM | 3 | Permit Number 47745 | 6013248.9695 | 2110513.26704 | 37.7758127253049 | -122.397649253932 | (37.7758127253049, -122.397649253932) | 6 | 2 | 9 | 28856 | 34 | |
2669 | 248462 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 130 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | Permit Number 779787 | 5997458.098 | 2107812.3026 | 37.767504613553 | -122.45207869525 | (37.767504613553, -122.45207869525) | 15 | 5 | 11 | 29492 | 9 | ||
2712 | 84610 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 535 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5987793.08995 | 2112320.51653 | 37.7793245451935 | -122.485839179975 | (37.7793245451935, -122.485839179975) | 11 | 6 | 2 | 55 | 26 | |||
2811 | 246987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 70 Clipper St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6004726.23458 | 2101068.69852 | 37.7494019174823 | -122.426458941248 | (37.7494019174823, -122.426458941248) | 2 | 4 | 5 | 28862 | 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) );