trees
6,714 rows where qSpecies_id = 7 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5057 | 72416 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3764 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5996845.41624 | 2115021.64069 | 37.7872644530409 | -122.454718783966 | (37.7872644530409, -122.454718783966) | 11 | 6 | 1 | 54 | 31 | |||
5104 | 212915 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 830 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992359.15804 | 2102812.51637 | 37.7534831218714 | -122.469351125951 | (37.7534831218714, -122.469351125951) | 1 | 8 | 4 | 56 | 12 | |||
5153 | 72328 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2836 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5996013.17509 | 2111084.70561 | 37.7764069050201 | -122.457313223935 | (37.7764069050201, -122.457313223935) | 11 | 6 | 2 | 54 | 16 | |||
5196 | 72221 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1927 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987523.8589 | 2102155.7654 | 37.7513992507221 | -122.486024209623 | (37.7513992507221, -122.486024209623) | 1 | 8 | 3 | 29491 | 35 | |||
5219 | 78496 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 837 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011334.80311 | 2104438.72087 | 37.7590266229899 | -122.403843331831 | (37.7590266229899, -122.403843331831) | 10 | 3 | 8 | 28856 | 29 | |||
5243 | 141564 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 500 LYON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000161.6495 | 2110729.8447 | 37.7756699411398 | -122.442937037183 | (37.7756699411398, -122.442937037183) | 15 | 5 | 11 | 29492 | 16 | |||
5278 | 235936 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2017 12:00:00 AM | 3 | Width 3ft | 6010180.29259 | 2103880.68421 | 37.7574298137383 | -122.40779684417 | (37.7574298137383, -122.40779684417) | 2 | 4 | 7 | 28859 | 19 | ||
5330 | 121676 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 65 Sotelo Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993867 | 2101351 | 37.7495571916966 | -122.464030639739 | (37.7495571916966, -122.464030639739) | 1 | 8 | 4 | 29491 | 40 | ||||
5337 | 178722 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 490 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002144.30749 | 2090601.92472 | 37.7205162706894 | -122.434638963227 | (37.7205162706894, -122.434638963227) | 9 | 7 | 6 | 28861 | 5 | |||
5398 | 71818 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1274 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5988967.2555 | 2106670.2084 | 37.7638787087739 | -122.481363401299 | (37.7638787087739, -122.481363401299) | 1 | 8 | 3 | 56 | 35 | |||
5445 | 71037 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2655 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5990171.0618 | 2097314.9079 | 37.7382614326886 | -122.476516364987 | (37.7382614326886, -122.476516364987) | 1 | 8 | 3 | 29491 | 35 | |||
5448 | 140339 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1300x WEBSTER ST | 7 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6003689.95 | 2113371.7397 | 37.7831244557567 | -122.430920367043 | (37.7831244557567, -122.430920367043) | 15 | 9 | 11 | 29490 | 41 | |||
5463 | 212518 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1845 Monterey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5992471.49152 | 2095369.46244 | 37.7330528811753 | -122.468421185611 | (37.7330528811753, -122.468421185611) | 9 | 8 | 4 | 59 | 40 | |||
5566 | 78781 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 75 Laura St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | 5997342.70536 | 2086993.54413 | 37.7103347346378 | -122.450976426135 | (37.7103347346378, -122.450976426135) | 9 | 7 | 6 | 28861 | 25 | |||
5585 | 100886 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Welsh St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013501.81999 | 2111894.49362 | 37.7796193360911 | -122.396871432992 | (37.7796193360911, -122.396871432992) | 6 | 2 | 9 | 28856 | 34 | |||
5591 | 212726 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1273 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 5992975.27742 | 2106809.78649 | 37.7644941673851 | -122.467511131939 | (37.7644941673851, -122.467511131939) | 11 | 8 | 11 | 56 | 12 | |||
5593 | 78471 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 62 Colby St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6007985.29967 | 2093778.54228 | 37.7295684489024 | -122.414673138765 | (37.7295684489024, -122.414673138765) | 9 | 3 | 7 | 309 | 28 | |||
5643 | 73340 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 591 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5990617.8075 | 2111391.14287 | 37.7769369378188 | -122.475999510441 | (37.7769369378188, -122.475999510441) | 11 | 6 | 2 | 55 | 26 | |||
5673 | 142341 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 501 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6000096.9145 | 2110881.9778 | 37.7760839689842 | -122.443171899624 | (37.7760839689842, -122.443171899624) | 15 | 5 | 11 | 29492 | 16 | |||
5714 | 259658 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 239 Stonecrest Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990787 | 2092898 | 37.7261694250404 | -122.474064598028 | (37.7261694250404, -122.474064598028) | 9 | 8 | 4 | 64 | 40 | ||||
5777 | 236886 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 19 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999794.84017 | 2107740.78747 | 37.7674418258017 | -122.443991102207 | (37.7674418258017, -122.443991102207) | 15 | 5 | 5 | 29492 | 9 | |||
5783 | 78260 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 567 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011132.16494 | 2092178.53307 | 37.7253514585786 | -122.403681510512 | (37.7253514585786, -122.403681510512) | 10 | 3 | 7 | 309 | 28 | |||
5789 | 142614 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 GREENWICH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6009469.9119 | 2120131.871 | 37.8020119312896 | -122.411401700731 | (37.8020119312896, -122.411401700731) | 3 | 1 | 10 | 308 | 23 | |||
5812 | 237501 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3717 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003602.08527 | 2103592.54155 | 37.7562681837431 | -122.430526337427 | (37.7562681837431, -122.430526337427) | 2 | 4 | 5 | 28862 | 22 | |||
5823 | 73063 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 774 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5992292.3763 | 2110183.95951 | 37.7737192935019 | -122.470118792738 | (37.7737192935019, -122.470118792738) | 11 | 6 | 2 | 54 | 11 | |||
5829 | 70329 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 791 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5988807.23069 | 2109962.85259 | 37.7729101002624 | -122.482158112101 | (37.7729101002624, -122.482158112101) | 11 | 6 | 2 | 55 | 26 | |||
5866 | 73526 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 807 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009578.52705 | 2116144.74687 | 37.7910703569642 | -122.410744096059 | (37.7910703569642, -122.410744096059) | 5 | 1 | 10 | 28857 | 21 | |||
5910 | 24288 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 340 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6001280.10777 | 2086581.35963 | 37.7094275956588 | -122.437338476184 | (37.7094275956588, -122.437338476184) | 9 | 7 | 6 | 28861 | 5 | |||
6052 | 235985 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 921 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004398.25101 | 2103505.33732 | 37.7560738114594 | -122.427766708382 | (37.7560738114594, -122.427766708382) | 2 | 4 | 5 | 28862 | 22 | |||
6079 | 212891 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1439 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991128.6884 | 2105597.85808 | 37.7610597509203 | -122.47380949522 | (37.7610597509203, -122.47380949522) | 1 | 8 | 4 | 56 | 12 | |||
6135 | 236937 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 342 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008931.13659 | 2096699.45171 | 37.7376417330755 | -122.411609564953 | (37.7376417330755, -122.411609564953) | 10 | 7 | 7 | 28859 | 2 | |||
6218 | 214210 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2 Edgehill Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994958.11276 | 2099177.21478 | 37.7436513456346 | -122.460100100459 | (37.7436513456346, -122.460100100459) | 1 | 8 | 4 | 59 | 40 | |||
6310 | 71322 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 426 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6003937.60452 | 2089980.93172 | 37.718912802856 | -122.428395868697 | (37.718912802856, -122.428395868697) | 9 | 7 | 6 | 28861 | 5 | |||
6466 | 261198 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 690x Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007331 | 2095336 | 37.7338081055982 | -122.417045435619 | (37.7338081055982, -122.417045435619) | 2 | 7 | 7 | 28859 | 2 | ||||
6494 | 72378 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 543 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5995284.05494 | 2111855.93801 | 37.7784826006561 | -122.459891318727 | (37.7784826006561, -122.459891318727) | 11 | 6 | 2 | 54 | 11 | |||
6595 | 236574 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2928 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009184.64361 | 2105006.14989 | 37.7604642981045 | -122.41131971344 | (37.7604642981045, -122.41131971344) | 2 | 4 | 7 | 28859 | 19 | |||
6598 | 261578 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 496 Urbano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
6681 | 70524 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 81 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6004889.28958 | 2092935.46604 | 37.7270791147056 | -122.425316399345 | (37.7270791147056, -122.425316399345) | 9 | 7 | 6 | 28861 | 5 | |||
6743 | 237502 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3707 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003619.47904 | 2103592.43752 | 37.7562688834292 | -122.430466176382 | (37.7562688834292, -122.430466176382) | 2 | 4 | 5 | 28862 | 22 | |||
6773 | 72338 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 854 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988539.28579 | 2110148.33783 | 37.773403802887 | -122.483098552076 | (37.773403802887, -122.483098552076) | 11 | 6 | 2 | 55 | 26 | |||
6844 | 235670 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 69 Elgin Park | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6005833.06667 | 2108709.07327 | 37.7704431026896 | -122.423174504696 | (37.7704431026896, -122.423174504696) | 8 | 2 | 5 | 28853 | 19 | |||
6867 | 260482 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
6988 | 72005 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1963 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5987221.7723 | 2101915.2958 | 37.7507213765199 | -122.487051188188 | (37.7507213765199, -122.487051188188) | 1 | 8 | 3 | 29491 | 35 | |||
7033 | 214228 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 714 Detroit St | 16 | Side Yard : Yard | Tree | Private 2 | 5 | 5999467.54728 | 2095443.9032 | 37.733658896535 | -122.444239403229 | (37.733658896535, -122.444239403229) | 9 | 7 | 4 | 63 | 40 | ||||
7114 | 20035 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
7158 | 261760 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 45 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007217 | 2095455 | 37.7341284399303 | -122.417447999393 | (37.7341284399303, -122.417447999393) | 2 | 7 | 7 | 28859 | 2 | ||||
7227 | 181941 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2338 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985894.7639 | 2098931.5489 | 37.7424513496728 | -122.49142044264 | (37.7424513496728, -122.49142044264) | 1 | 8 | 3 | 29491 | 35 | |||
7250 | 72385 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 686 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5995057.69186 | 2110887.03516 | 37.7758092299392 | -122.460604158861 | (37.7758092299392, -122.460604158861) | 11 | 6 | 2 | 54 | 11 | |||
7292 | 139423 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2683 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999790.4795 | 2113984.7901 | 37.7845860157612 | -122.444454981067 | (37.7845860157612, -122.444454981067) | 15 | 6 | 11 | 29490 | 31 | |||
7329 | 83337 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2815 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6000055.78832 | 2117427.57453 | 37.7940541366405 | -122.443784531525 | (37.7940541366405, -122.443784531525) | 13 | 9 | 1 | 57 | 27 | |||
7355 | 218024 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2439 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992321.61488 | 2098826.36929 | 37.7425360172282 | -122.469190857781 | (37.7425360172282, -122.469190857781) | 1 | 8 | 4 | 29491 | 40 | |||
7370 | 78746 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 355 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009102.50426 | 2088111.28549 | 37.7140700552715 | -122.410410826197 | (37.7140700552715, -122.410410826197) | 9 | 7 | 8 | 309 | 39 | |||
7394 | 236442 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1098 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998931 | 2106271 | 37.7633568442315 | -122.446873221995 | (37.7633568442315, -122.446873221995) | 15 | 5 | 11 | 29492 | 9 | |||
7481 | 236548 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1199x Eugenia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008197.38645 | 2097705.34234 | 37.7403625015365 | -122.414217644728 | (37.7403625015365, -122.414217644728) | 2 | 7 | 7 | 28859 | 2 | |||
7520 | 236941 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 42 Putnam St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009158.27721 | 2097193.88285 | 37.7390120723534 | -122.410859138235 | (37.7390120723534, -122.410859138235) | 10 | 7 | 7 | 28859 | 2 | |||
7579 | 72318 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 539 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 9x6 | 5995283.47328 | 2111879.02377 | 37.7785459545642 | -122.459895003637 | (37.7785459545642, -122.459895003637) | 11 | 6 | 2 | 54 | 11 | |||
7595 | 178710 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 500 London St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001568.61805 | 2090782.47378 | 37.720979319025 | -122.43664185145 | (37.720979319025, -122.43664185145) | 9 | 7 | 6 | 28861 | 5 | |||
7604 | 70169 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 5233 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5982394.50702 | 2111657.31782 | 37.7771875318175 | -122.504465669217 | (37.7771875318175, -122.504465669217) | 11 | 6 | 2 | 55 | 26 | |||
7618 | 235999 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 365 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6003615.09862 | 2098623.52813 | 37.7426251724083 | -122.43012686309 | (37.7426251724083, -122.43012686309) | 2 | 7 | 5 | 63 | 22 | |||
7676 | 78416 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2959 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5990231.30854 | 2095554.29925 | 37.7334307457305 | -122.47617950378 | (37.7334307457305, -122.47617950378) | 1 | 8 | 4 | 64 | 35 | |||
7792 | 81654 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1773 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6014140.03196 | 2096118.29222 | 37.7363368024053 | -122.393559125566 | (37.7363368024053, -122.393559125566) | 10 | 3 | 8 | 58 | 1 | |||
7843 | 202011 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 35 Wheat St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6012102.79015 | 2091227.84985 | 37.7227952498849 | -122.400259388686 | (37.7227952498849, -122.400259388686) | 10 | 3 | 8 | 58 | 1 | |||
7922 | 135849 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2456 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007515.30382 | 2120841.49853 | 37.8038505659037 | -122.418215928918 | (37.8038505659037, -122.418215928918) | 5 | 1 | 1 | 308 | 32 | |||
7950 | 78312 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 546 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002946.84027 | 2090441.19936 | 37.7201204817617 | -122.431853395021 | (37.7201204817617, -122.431853395021) | 9 | 7 | 6 | 28861 | 5 | |||
7976 | 20040 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
8070 | 72336 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 778 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5988856.36837 | 2110023.77436 | 37.7730802324948 | -122.481992604718 | (37.7730802324948, -122.481992604718) | 11 | 6 | 2 | 55 | 26 | |||
8216 | 261364 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 37 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007227 | 2095555 | 37.734403580666 | -122.417420510703 | (37.734403580666, -122.417420510703) | 2 | 7 | 7 | 28859 | 2 | ||||
8220 | 212707 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1439 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5994565.98091 | 2105717.62937 | 37.7615870971916 | -122.461930160547 | (37.7615870971916, -122.461930160547) | 1 | 5 | 11 | 56 | 12 | |||
8262 | 236009 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 342 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6003704.29788 | 2098672.67135 | 37.7427651599925 | -122.429821942527 | (37.7427651599925, -122.429821942527) | 2 | 7 | 5 | 63 | 22 | |||
8287 | 196310 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 928 Clara St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6011726.41935 | 2111671.91567 | 37.7789092071182 | -122.402997684908 | (37.7789092071182, -122.402997684908) | 14 | 2 | 9 | 28856 | 34 | |||
8314 | 71206 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 838 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988535.53493 | 2110268.06328 | 37.7737323174457 | -122.483120303898 | (37.7737323174457, -122.483120303898) | 11 | 6 | 2 | 55 | 26 | |||
8610 | 71799 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2136 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5997619.6494 | 2109914.3568 | 37.7732855671288 | -122.451671561936 | (37.7732855671288, -122.451671561936) | 15 | 5 | 11 | 29492 | 16 | |||
8768 | 246988 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 70 Clipper St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6004704.08454 | 2101068.96131 | 37.7494013868777 | -122.426535555381 | (37.7494013868777, -122.426535555381) | 2 | 4 | 5 | 28862 | 22 | |||
8792 | 71157 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 807 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6009578.49301 | 2116131.05118 | 37.7910327500084 | -122.410743246197 | (37.7910327500084, -122.410743246197) | 5 | 1 | 10 | 28857 | 21 | |||
8811 | 80603 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 888 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015452.3757 | 2105055.85533 | 37.7609503151357 | -122.389645800319 | (37.7609503151357, -122.389645800319) | 10 | 3 | 8 | 28856 | 29 | |||
8841 | 178711 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 500 London St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001558.80757 | 2090766.26793 | 37.7209342638804 | -122.436674603871 | (37.7209342638804, -122.436674603871) | 9 | 7 | 6 | 28861 | 5 | |||
8864 | 236310 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3186 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007726.45399 | 2102693.43972 | 37.7540322344234 | -122.416199135408 | (37.7540322344234, -122.416199135408) | 2 | 4 | 7 | 28859 | 19 | |||
8907 | 78209 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 602 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011148.7159 | 2091968.96247 | 37.7247769455958 | -122.403609556646 | (37.7247769455958, -122.403609556646) | 10 | 3 | 7 | 309 | 28 | |||
8994 | 73532 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 838 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988535.77242 | 2110247.48353 | 37.7736758249905 | -122.483117973661 | (37.7736758249905, -122.483117973661) | 11 | 6 | 2 | 55 | 26 | |||
9007 | 23899 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1600X Webster St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 6 | 6003605.1476962 | 2114190.7261663 | 37.785368381567 | -122.431272227533 | (37.785368381567, -122.431272227533) | 13 | 9 | 11 | 29490 | 13 | |||
9021 | 236620 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3031 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008725.435 | 2102707.57209 | 37.7541271596615 | -122.412745405998 | (37.7541271596615, -122.412745405998) | 2 | 4 | 7 | 28859 | 19 | |||
9072 | 235773 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1449 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007770.63381 | 2107353.8886 | 37.7668312365099 | -122.416376430431 | (37.7668312365099, -122.416376430431) | 8 | 4 | 7 | 28853 | 19 | |||
9103 | 236319 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2870 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6008996.29845 | 2103350.92649 | 37.7559088650107 | -122.411854149066 | (37.7559088650107, -122.411854149066) | 2 | 4 | 7 | 28859 | 19 | |||
9114 | 72295 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 142 Freelon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6013238.89024 | 2111406.12615 | 37.7782637520155 | -122.397746762019 | (37.7782637520155, -122.397746762019) | 6 | 2 | 9 | 28856 | 34 | |||
9204 | 78231 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 924 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6008861.56541 | 2090881.25094 | 37.7216622938669 | -122.411439180279 | (37.7216622938669, -122.411439180279) | 9 | 3 | 7 | 309 | 28 | |||
9239 | 236546 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1199x Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008220.5972 | 2097704.41619 | 37.7403612622727 | -122.414137325379 | (37.7403612622727, -122.414137325379) | 2 | 7 | 7 | 28859 | 2 | |||
9256 | 236946 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 147 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007380.39816 | 2097532.19381 | 37.7398411492515 | -122.417030208789 | (37.7398411492515, -122.417030208789) | 2 | 7 | 7 | 28859 | 2 | |||
9331 | 236995 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 290X Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007943.27798 | 2096094.30116 | 37.7359246593032 | -122.414982254625 | (37.7359246593032, -122.414982254625) | 2 | 7 | 7 | 28859 | 2 | |||
9340 | 78715 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 190 Schwerin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008812.7369 | 2086938.04091 | 37.7108323187195 | -122.411329543927 | (37.7108323187195, -122.411329543927) | 9 | 7 | 8 | 309 | 39 | |||
9390 | 70849 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 342 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6002406.02923 | 2091608.42351 | 37.7232947459327 | -122.433806177538 | (37.7232947459327, -122.433806177538) | 9 | 7 | 6 | 28861 | 5 | |||
9402 | 72253 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 538 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002525.55388 | 2090783.37547 | 37.7210361300962 | -122.433334076631 | (37.7210361300962, -122.433334076631) | 9 | 7 | 6 | 28861 | 5 | |||
9410 | 79837 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2808 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6006109.45612 | 2120466.37489 | 37.8027413403128 | -122.423054277046 | (37.8027413403128, -122.423054277046) | 5 | 9 | 1 | 28858 | 32 | |||
9472 | 78510 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 750 Eucalyptus Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988931.24396 | 2094774.45392 | 37.7312140158088 | -122.480617072624 | (37.7312140158088, -122.480617072624) | 1 | 8 | 4 | 64 | 35 | |||
9561 | 73853 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 25 Newton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6000885.5664 | 2088247.40697 | 37.713979754329 | -122.438821382721 | (37.713979754329, -122.438821382721) | 9 | 7 | 6 | 28861 | 5 | |||
9610 | 196158 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 390x Hampshire St | 4 | Median : Cutout | Tree | DPW 1 | 8 | Width 5ft | 6010042.15672 | 2106501.92637 | 37.7646194177702 | -122.408459468244 | (37.7646194177702, -122.408459468244) | 8 | 4 | 8 | 28853 | 19 | |||
9652 | 178811 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 19 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6007941.79133 | 2094126.71346 | 37.7305220072776 | -122.414848183713 | (37.7305220072776, -122.414848183713) | 9 | 3 | 7 | 309 | 28 | |||
9776 | 236304 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 128 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006662 | 2102868 | 37.7544516263091 | -122.419892666236 | (37.7544516263091, -122.419892666236) | 2 | 4 | 7 | 28859 | 19 | |||
9836 | 218111 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 70 Lopez Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5993944.94512 | 2100501.16931 | 37.747228264177 | -122.463699432805 | (37.747228264177, -122.463699432805) | 1 | 8 | 4 | 29491 | 40 | |||
10094 | 212393 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 55 San Rafael Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5991911.35138 | 2095658.63831 | 37.7338145152114 | -122.470378772281 | (37.7338145152114, -122.470378772281) | 9 | 8 | 4 | 59 | 40 | |||
10115 | 236996 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1100 Eugenia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008130 | 2097670 | 37.7402616738659 | -122.414448140958 | (37.7402616738659, -122.414448140958) | 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) );