trees
6,714 rows where qSpecies_id = 7 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
191966 | 212337 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 129 Kirkham St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 5994398.77706 | 2105288.17084 | 37.7603982878597 | -122.462477294588 | (37.7603982878597, -122.462477294588) | 1 | 5 | 4 | 56 | 12 | |||
191960 | 196104 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 151 Wisconsin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6012604.3694 | 2106752.97447 | 37.7654518950106 | -122.399615029811 | (37.7654518950106, -122.399615029811) | 14 | 3 | 8 | 28856 | 20 | |||
191943 | 235820 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 9 Lundys Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6007238.41077 | 2099662.40908 | 37.7456822567369 | -122.417672090021 | (37.7456822567369, -122.417672090021) | 2 | 7 | 7 | 28859 | 2 | |||
191936 | 100987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
191874 | 135724 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1910 Baker St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5999982.20185 | 2115576.56737 | 37.7889675594589 | -122.443906093806 | (37.7889675594589, -122.443906093806) | 13 | 6 | 1 | 29490 | 27 | |||
191851 | 65137 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1115 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1989 12:00:00 AM | 7 | 3x3 | Permit Number 27112 | 5992104.89542 | 2111324.94968 | 37.776841303137 | -122.470850442714 | (37.776841303137, -122.470850442714) | 11 | 6 | 2 | 54 | 11 | |
191829 | 212686 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 57 Beachmont Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5990828.26493 | 2095468.36249 | 37.7332293839098 | -122.474109410116 | (37.7332293839098, -122.474109410116) | 1 | 8 | 4 | 64 | 40 | |||
191825 | 236714 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 458 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6002154.83596 | 2101510.9788 | 37.7504706178297 | -122.435382521803 | (37.7504706178297, -122.435382521803) | 2 | 4 | 5 | 28862 | 22 | |||
191711 | 236626 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3415 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007418.40503 | 2104391.72154 | 37.7586780008055 | -122.417384790769 | (37.7586780008055, -122.417384790769) | 2 | 4 | 7 | 28859 | 19 | |||
191684 | 32013 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1530 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50870 | 5996920.28607 | 2105926.83043 | 37.7622967674964 | -122.453802732728 | (37.7622967674964, -122.453802732728) | 15 | 5 | 11 | 29492 | 12 | |
191682 | 46831 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 544 Excelsior Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44905 | 6003706.54447011 | 2091877.16367868 | 37.7241063598081 | -122.429329698126 | (37.7241063598081, -122.429329698126) | 9 | 7 | 6 | 28861 | 5 | ||
191668 | 237818 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 320 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001561.6197 | 2096237.38568 | 37.7359568640002 | -122.437056385867 | (37.7359568640002, -122.437056385867) | 2 | 7 | 5 | 63 | 7 | |||
191638 | 212502 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 65 Sotelo Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993877.40104 | 2101342.6877 | 37.7495349676665 | -122.463994069577 | (37.7495349676665, -122.463994069577) | 1 | 8 | 4 | 29491 | 40 | |||
191575 | 199862 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1455 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016004.4926 | 2094023.6514 | 37.7306887611767 | -122.386966805875 | (37.7306887611767, -122.386966805875) | 10 | 3 | 8 | 58 | 1 | |||
191546 | 64562 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1419 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/1988 12:00:00 AM | Permit Number 25454 | 6009728.96259143 | 2118520.44874424 | 37.797601889078 | -122.410391411409 | (37.797601889078, -122.410391411409) | 3 | 1 | 10 | 308 | 4 | ||
191492 | 42524 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 698 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42637 | 6000682.97448864 | 2100901.41160372 | 37.7487131932097 | -122.440428602512 | (37.7487131932097, -122.440428602512) | 2 | 4 | 5 | 28862 | 22 | |||
191470 | 236979 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 76 Manchester St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6008203.24501 | 2099681.09302 | 37.7457878047614 | -122.414337147542 | (37.7457878047614, -122.414337147542) | 2 | 7 | 7 | 28859 | 2 | |||
191454 | 196209 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 655 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6013962.20415 | 2111085.21756 | 37.7774228624975 | -122.395222049367 | (37.7774228624975, -122.395222049367) | 6 | 2 | 9 | 28856 | 34 | |||
191451 | 58938 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1354 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/1980 12:00:00 AM | 4 | Permit Number 18216 | 6011960.10297 | 2102068.33335 | 37.7525529728507 | -122.401514142577 | (37.7525529728507, -122.401514142577) | 10 | 3 | 8 | 28856 | 29 | ||
191422 | 235775 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1402 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6007905.65608 | 2107401.85909 | 37.7669705441841 | -122.415912806534 | (37.7669705441841, -122.415912806534) | 8 | 4 | 7 | 28853 | 19 | |||
191411 | 213054 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 66 Vasquez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5995388.32425 | 2099941.25809 | 37.7457739534089 | -122.458667843743 | (37.7457739534089, -122.458667843743) | 1 | 8 | 4 | 59 | 40 | |||
191404 | 68374 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1560 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32196 | 5997920.52398259 | 2105294.68200547 | 37.7606183420081 | -122.45029773161 | (37.7606183420081, -122.45029773161) | 15 | 5 | 11 | 29492 | 12 | ||
191391 | 237512 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3930 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003547.77733 | 2102465.94736 | 37.7531717459984 | -122.430633765039 | (37.7531717459984, -122.430633765039) | 2 | 4 | 5 | 28862 | 22 | |||
191357 | 32114 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 274 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | Permit Number 35481 | 6003526.31503557 | 2106685.69325753 | 37.7647569449851 | -122.431009130874 | (37.7647569449851, -122.431009130874) | 15 | 4 | 5 | 28862 | 3 | ||
191285 | 212341 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 136 Lawton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 5993819.43048 | 2104642.8186 | 37.7585929384414 | -122.464434112371 | (37.7585929384414, -122.464434112371) | 1 | 8 | 4 | 56 | 12 | |||
191278 | 178790 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 717 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004510.99834 | 2092208.26792 | 37.7250610099504 | -122.426572388011 | (37.7250610099504, -122.426572388011) | 9 | 7 | 6 | 28861 | 5 | |||
191273 | 2470 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1875 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/1998 12:00:00 AM | 7 | 5x5 | 6003922.7717 | 2114866.5529 | 37.787242026635 | -122.430221576405 | (37.787242026635, -122.430221576405) | 13 | 9 | 11 | 29490 | 27 | ||
191244 | 237513 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3957 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003406.44135 | 2102412.52203 | 37.7530170446231 | -122.431118719946 | (37.7530170446231, -122.431118719946) | 2 | 4 | 5 | 28862 | 22 | |||
191227 | 236485 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 270 Ellsworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008055.14191 | 2097339.63762 | 37.7393503658325 | -122.414683597876 | (37.7393503658325, -122.414683597876) | 2 | 7 | 7 | 28859 | 2 | |||
191222 | 237695 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 291 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003521.23948 | 2106625.5957 | 37.7645916440088 | -122.431022396289 | (37.7645916440088, -122.431022396289) | 15 | 4 | 5 | 28862 | 3 | |||
191206 | 140300 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 144 COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5997825.8983 | 2110052.4968 | 37.773676673537 | -122.450968085372 | (37.773676673537, -122.450968085372) | 15 | 5 | 11 | 29492 | 16 | |||
191182 | 41205 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3525 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 6 | Permit Number 41911 | 5999706.5792 | 2120652.81241 | 37.8028898552495 | -122.445224820077 | (37.8028898552495, -122.445224820077) | 13 | 9 | 1 | 57 | 17 | |
191176 | 212963 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 549 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5994032.27553 | 2106632.00589 | 37.7640669966217 | -122.46384238723 | (37.7640669966217, -122.46384238723) | 1 | 5 | 11 | 56 | 12 | |||
191165 | 235824 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1900 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009488.05134 | 2105880.59671 | 37.7628823421716 | -122.410332104947 | (37.7628823421716, -122.410332104947) | 8 | 4 | 7 | 28859 | 19 | |||
191161 | 212904 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1766 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5991242.87508 | 2103324.19698 | 37.7548234912351 | -122.473248749035 | (37.7548234912351, -122.473248749035) | 1 | 8 | 4 | 56 | 12 | |||
191154 | 113979 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 1180 STANYAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
191143 | 236383 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 411 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6003752.37319 | 2100094.57375 | 37.7466720973408 | -122.42975710682 | (37.7466720973408, -122.42975710682) | 2 | 7 | 5 | 63 | 22 | |||
191130 | 32055 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3508 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | Permit Number 35433 | 6003440.28387664 | 2106564.73468813 | 37.7644199468011 | -122.431298055144 | (37.7644199468011, -122.431298055144) | 15 | 4 | 5 | 28862 | 3 | ||
191077 | 88714 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 871 Page St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51655 | 6002408 | 2109501 | 37.7724236544526 | -122.435078456775 | (37.7724236544526, -122.435078456775) | 15 | 5 | 11 | 29492 | 9 | |||
191073 | 40506 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 190 Aptos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1999 12:00:00 AM | Permit Number 41574 | 5992684.89074648 | 2093715.48632122 | 37.7285237971234 | -122.467563175833 | (37.7285237971234, -122.467563175833) | 9 | 8 | 4 | 59 | 40 | ||
191050 | 178697 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 170 Lawrence Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 5996822.29762 | 2087264.10807 | 37.7110478340594 | -122.452794569318 | (37.7110478340594, -122.452794569318) | 9 | 7 | 6 | 28861 | 25 | |||
191013 | 43526 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1341 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43201 | 6001444.90531013 | 2110398.42991919 | 37.7748330382642 | -122.438474196909 | (37.7748330382642, -122.438474196909) | 15 | 5 | 11 | 29492 | 10 | ||
191008 | 142543 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301 FRANCISCO ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | Width 0ft | 6009503.7886 | 2121178.1337 | 37.8048866083098 | -122.411358426924 | (37.8048866083098, -122.411358426924) | 3 | 1 | 10 | 308 | 23 | |||
190987 | 236908 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1180 Stanyan St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10 | Width 3ft | 5997407.84299 | 2106068.89598 | 37.7627147840868 | -122.452126715671 | (37.7627147840868, -122.452126715671) | 15 | 5 | 11 | 29492 | 9 | |||
190982 | 237494 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1211 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003242.66605 | 2101186.9809 | 37.7496427154599 | -122.431597598162 | (37.7496427154599, -122.431597598162) | 2 | 4 | 5 | 28862 | 22 | |||
190963 | 47649 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 140 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | 1 | Permit Number 45453 | 5988695.34077 | 2114405.33435 | 37.7851014018397 | -122.482870788727 | (37.7851014018397, -122.482870788727) | 11 | 6 | 2 | 55 | 26 | ||
190953 | 237572 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 559 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003674.54291 | 2104983.3245 | 37.7600910470876 | -122.43037497974 | (37.7600910470876, -122.43037497974) | 2 | 4 | 5 | 28862 | 3 | |||
190951 | 139090 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2301 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001109.2495 | 2113824.7266 | 37.7842216800055 | -122.439881012352 | (37.7842216800055, -122.439881012352) | 15 | 6 | 11 | 29490 | 13 | |||
190924 | 121966 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 26 15th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5991179.29264 | 2114937.5267 | 37.7867068686376 | -122.47431602898 | (37.7867068686376, -122.47431602898) | 11 | 6 | 1 | 54 | 33 | ||||
190912 | 213096 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 240 Maywood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994294.8021 | 2095133.60829 | 37.7325104317091 | -122.462100467869 | (37.7325104317091, -122.462100467869) | 9 | 8 | 4 | 59 | 40 | |||
190876 | 46089 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2001 12:00:00 AM | 3 | Permit Number 44465 | 5989928.03736 | 2114622.78599 | 37.7857701098965 | -122.478621999998 | (37.7857701098965, -122.478621999998) | 11 | 6 | 2 | 55 | 26 | ||
190812 | 212425 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 383 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992502.97642 | 2094257.7891 | 37.7300023214415 | -122.468231492484 | (37.7300023214415, -122.468231492484) | 9 | 8 | 4 | 59 | 40 | |||
190799 | 178703 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 Rae Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998317.89725 | 2087761.99008 | 37.7125004936668 | -122.447661256171 | (37.7125004936668, -122.447661256171) | 9 | 7 | 6 | 28861 | 25 | |||
190792 | 212950 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 418 Hugo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994451.24534 | 2107037.42516 | 37.7652043071536 | -122.462422712057 | (37.7652043071536, -122.462422712057) | 11 | 5 | 11 | 56 | 12 | |||
190765 | 57413 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/1976 12:00:00 AM | 5 | Permit Number 16255 | 5996562.3267 | 2113747.4862 | 37.7837497228996 | -122.455606076565 | (37.7837497228996, -122.455606076565) | 11 | 6 | 1 | 54 | 31 | ||
190751 | 135697 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Walnut St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5998449.317 | 2116481.46771 | 37.7913646187353 | -122.449274868335 | (37.7913646187353, -122.449274868335) | 13 | 6 | 1 | 54 | 31 | |||
190729 | 39730 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3400 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2008 12:00:00 AM | 3x3 | Permit Number 50111 | 6004193.79653014 | 2106606.54205997 | 37.7645774138884 | -122.42869484348 | (37.7645774138884, -122.42869484348) | 8 | 4 | 5 | 28862 | 3 | ||
190706 | 237692 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 242 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003513.19366 | 2106798.97901 | 37.7650672567749 | -122.431062600468 | (37.7650672567749, -122.431062600468) | 15 | 4 | 5 | 28862 | 3 | |||
190701 | 196275 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 89 Kiska Rd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6018699.22943 | 2093690.01585 | 37.729921505667 | -122.377627436781 | (37.729921505667, -122.377627436781) | 10 | 3 | 8 | 58 | 1 | |||
190646 | 244029 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 501X Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1999 12:00:00 AM | 7 | Width 0ft | Permit Number 41876 | 5997510 | 2108663 | 37.7698433835647 | -122.451960555076 | (37.7698433835647, -122.451960555076) | 15 | 5 | 11 | 29492 | 9 | |
190622 | 212657 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 343 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5993218.2804 | 2089467.7966 | 37.7168914560454 | -122.465410797693 | (37.7168914560454, -122.465410797693) | 9 | 8 | 6 | 64 | 24 | ||||
190620 | 140058 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 428 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6005721.0754 | 2111392.7623 | 37.7778055435978 | -122.42375273139 | (37.7778055435978, -122.42375273139) | 7 | 9 | 11 | 28852 | 10 | |||
190580 | 178706 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 811 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001828.84195 | 2089087.65401 | 37.7163405070928 | -122.435621147914 | (37.7163405070928, -122.435621147914) | 9 | 7 | 6 | 28861 | 5 | |||
190558 | 237852 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 204 Addison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6002664.59723 | 2097398.56275 | 37.7392078214825 | -122.433325904463 | (37.7392078214825, -122.433325904463) | 2 | 7 | 5 | 63 | 7 | |||
190557 | 49600 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 268@ MURRY Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47071 | 6006167.85740963 | 2096068.40559156 | 37.7357536291509 | -122.421118761735 | (37.7357536291509, -122.421118761735) | 2 | 7 | 7 | 28859 | 2 | ||
190527 | 106859 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 946 RHODE ISLAND ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | 14 | 3x3 | Permit Number 773008 | 6011839.2 | 2104029.4 | 37.7579308843014 | -122.402070102772 | (37.7579308843014, -122.402070102772) | 10 | 3 | 8 | 28856 | 29 | ||
190466 | 236538 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007123.60944 | 2096775.02412 | 37.73774768042 | -122.417864419915 | (37.73774768042, -122.417864419915) | 2 | 7 | 7 | 28859 | 2 | |||
190448 | 34679 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2069 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 4 | Permit Number 41918 | 6003062.63239 | 2118890.11528 | 37.7982409403347 | -122.43348511594 | (37.7982409403347, -122.43348511594) | 13 | 9 | 1 | 57 | 17 | |
190425 | 94668 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2650 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53805 | 6002274 | 2096516 | 37.7367623413593 | -122.434613321972 | (37.7367623413593, -122.434613321972) | 2 | 7 | 5 | 63 | 7 | |
190385 | 67406 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 418 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/1992 12:00:00 AM | 6 | Permit Number 30905 | 5989386.42429 | 2112458.89246 | 37.7797972045435 | -122.480337365381 | (37.7797972045435, -122.480337365381) | 11 | 6 | 2 | 55 | 26 | |
190374 | 212535 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 26 Fairfield Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5993887.49703 | 2092969.0976 | 37.7265437563637 | -122.46335159301 | (37.7265437563637, -122.46335159301) | 9 | 8 | 4 | 59 | 40 | |||
190282 | 235957 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 176 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009893.69877 | 2100072.69373 | 37.7469578695161 | -122.40851939365 | (37.7469578695161, -122.40851939365) | 2 | 7 | 7 | 28859 | 2 | |||
190255 | 52334 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 449 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2005 12:00:00 AM | Permit Number 48485 | 5998866.25232859 | 2109203.1049245 | 37.7714039643354 | -122.447308208696 | (37.7714039643354, -122.447308208696) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
190228 | 35966 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 102 Leese St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39124 | 6005564.29083619 | 2096119.54100756 | 37.7358599920196 | -122.423209162873 | (37.7358599920196, -122.423209162873) | 2 | 7 | 7 | 28859 | 2 | ||
190184 | 48978 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2801 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2002 12:00:00 AM | 4 | Permit Number 46165 | 6004347.6822 | 2118813.41296 | 37.7981031596905 | -122.429032988006 | (37.7981031596905, -122.429032988006) | 13 | 9 | 1 | 57 | 17 | ||
190179 | 52389 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 99X Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.424094095206 | (37.7368773658256, -122.424094095206) | 2 | 7 | 7 | 28859 | 2 |
190169 | 88601 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 475 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51545 | 5998538 | 2106431 | 37.7637737045649 | -122.448243997102 | (37.7637737045649, -122.448243997102) | 15 | 5 | 11 | 29492 | 9 | ||
190163 | 235698 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 427 Webster St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6004081.68484 | 2110241.59311 | 37.774552035881 | -122.429341841278 | (37.774552035881, -122.429341841278) | 7 | 9 | 11 | 29492 | 10 | |||
190144 | 33499 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37589 | 6006683.58482984 | 2099106.89574168 | 37.7441257054073 | -122.419551194294 | (37.7441257054073, -122.419551194294) | 2 | 7 | 7 | 28859 | 2 | |||
190119 | 178801 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 408 Amherst St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007721.88414 | 2091888.43303 | 37.7243638114287 | -122.415450036091 | (37.7243638114287, -122.415450036091) | 9 | 3 | 7 | 309 | 28 | |||
190118 | 49800 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 61@ WEBSTER Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | Permit Number 46592 | 6004436.15215025 | 2109254.48297957 | 37.7718617337201 | -122.428045311452 | (37.7718617337201, -122.428045311452) | 7 | 9 | 11 | 28852 | 10 | ||
190030 | 237590 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 206 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001722.06122 | 2104635.06617 | 37.7590240230624 | -122.437102734223 | (37.7590240230624, -122.437102734223) | 2 | 4 | 5 | 28862 | 3 | |||
190028 | 61461 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 216 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1984 12:00:00 AM | Permit Number 21403 | 6004121.44411458 | 2107580.27481071 | 37.7672469543828 | -122.429014520985 | (37.7672469543828, -122.429014520985) | 8 | 4 | 5 | 28862 | 3 | ||
190015 | 235948 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009697.79921 | 2099893.28506 | 37.7464542797357 | -122.409184141931 | (37.7464542797357, -122.409184141931) | 2 | 7 | 7 | 28859 | 2 | |||
190000 | 212574 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 206 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997591.8701 | 2098808.75538 | 37.7427907798699 | -122.450966688289 | (37.7427907798699, -122.450966688289) | 9 | 7 | 4 | 59 | 40 | |||
189957 | 32808 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1731 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/2002 12:00:00 AM | Permit Number 37167 | 5999574.22766035 | 2110137.836464 | 37.7740109291532 | -122.444926501083 | (37.7740109291532, -122.444926501083) | 15 | 5 | 11 | 29492 | 16 | ||
189911 | 178777 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2 Santa Ysabel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001071.38378 | 2093033.50454 | 37.7271318680242 | -122.438521840107 | (37.7271318680242, -122.438521840107) | 9 | 7 | 6 | 28861 | 25 | |||
189897 | 62307 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 75 Loraine Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1985 12:00:00 AM | 12 | Permit Number 22445. Tree 1 on Anza | 5996139.53723 | 2112297.17389 | 37.7797432798479 | -122.456963823301 | (37.7797432798479, -122.456963823301) | 11 | 6 | 2 | 54 | 16 | |
189895 | 217978 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990688.63411 | 2097673.45476 | 37.7392759154444 | -122.474753036017 | (37.7392759154444, -122.474753036017) | 1 | 8 | 4 | 29491 | 40 | |||
189893 | 36659 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3015 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39467 | 6009053.74740729 | 2100920.4125739 | 37.749238441242 | -122.411483763084 | (37.749238441242, -122.411483763084) | 2 | 4 | 7 | 28859 | 19 | ||
189837 | 217927 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1751 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993085.35779 | 2103564.87368 | 37.7555908395728 | -122.466894482992 | (37.7555908395728, -122.466894482992) | 1 | 8 | 4 | 56 | 12 | |||
189830 | 236343 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005586.50435 | 2099363.64321 | 37.7447688189356 | -122.423362909076 | (37.7447688189356, -122.423362909076) | 2 | 7 | 5 | 28859 | 22 | |||
189748 | 236420 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 125 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997920.6891 | 2104887.77316 | 37.7595010819238 | -122.450267828709 | (37.7595010819238, -122.450267828709) | 15 | 5 | 11 | 28862 | 12 | |||
189734 | 235882 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 953 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009967.48402 | 2103644.11822 | 37.7567683407994 | -122.408516137227 | (37.7567683407994, -122.408516137227) | 2 | 4 | 7 | 28859 | 19 | |||
189725 | 34890 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1717 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38497 | 6003470.09933835 | 2114577.7664296 | 37.7864234422508 | -122.431767098133 | (37.7864234422508, -122.431767098133) | 13 | 9 | 11 | 29490 | 27 | ||||
189682 | 212406 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 235 San Leandro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992397.55515 | 2095176.02677 | 37.7325174841955 | -122.468662730899 | (37.7325174841955, -122.468662730899) | 9 | 8 | 4 | 59 | 40 | |||
189676 | 236895 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 501 Upper Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000088.48201 | 2107126.84515 | 37.7657728396692 | -122.442931344726 | (37.7657728396692, -122.442931344726) | 15 | 5 | 5 | 29492 | 9 | |||
189668 | 40554 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 155 San Rafael Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1999 12:00:00 AM | Permit Number 41595 | 5991899.17358621 | 2095177.01726748 | 37.732491400582 | -122.470385811314 | (37.732491400582, -122.470385811314) | 9 | 8 | 4 | 59 | 40 | ||
189579 | 113421 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 598X BENTON AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007207 | 2095355 | 37.7338532991757 | -122.417475487879 | (37.7338532991757, -122.417475487879) | 2 | 7 | 7 | 28859 | 2 |
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) );