trees
64 rows where qSpecies_id = 199
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1638 | 226334 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 1 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2019 12:00:00 AM | 3 | 3x6 | 6006673.91322 | 2103705.36513 | 37.756751509094 | -122.419910883878 | (37.756751509094, -122.419910883878) | 2 | 4 | 7 | 28859 | 19 | ||
4204 | 226336 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 25 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2019 12:00:00 AM | 3 | 3x6 | 6006679.39058 | 2103618.84473 | 37.7565142526416 | -122.419885801802 | (37.7565142526416, -122.419885801802) | 2 | 4 | 7 | 28859 | 19 | ||
5123 | 221985 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 90 Bartlett St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006632.52814 | 2103555.46037 | 37.756337573629 | -122.420043371116 | (37.756337573629, -122.420043371116) | 2 | 4 | 7 | 28859 | 19 | |||
5195 | 226335 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 19 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2019 12:00:00 AM | 3 | 3x6 | 6006677.49566 | 2103645.89142 | 37.7565884098515 | -122.419894274305 | (37.7565884098515, -122.419894274305) | 2 | 4 | 7 | 28859 | 19 | ||
6067 | 84814 | Permitted Site 7 | Albizia julibrissin :: Mimosa Silk Tree 199 | 678 PRECITA Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | Permit No. 49253 | 6010016.1 | 2100471.5 | 37.7480597580847 | -122.408124260646 | (37.7480597580847, -122.408124260646) | 2 | 7 | 7 | 28859 | 2 | |||
9956 | 226340 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 41 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2016 12:00:00 AM | 3 | 3x6 | 6006685.59051 | 2103479.17398 | 37.7561310982853 | -122.419854449627 | (37.7561310982853, -122.419854449627) | 2 | 4 | 7 | 28859 | 19 | ||
10589 | 221981 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 90 Bartlett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2019 12:00:00 AM | 3 | 3x6 | 6006627.76439 | 2103666.82862 | 37.7566430967157 | -122.420067749029 | (37.7566430967157, -122.420067749029) | 2 | 4 | 7 | 28859 | 19 | ||
10789 | 74329 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 121 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6004023.71662 | 2093082.18555 | 37.7274330338863 | -122.428319125933 | (37.7274330338863, -122.428319125933) | 9 | 7 | 6 | 28861 | 5 | |||
11070 | 221989 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 90 Bartlett St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2019 12:00:00 AM | 3 | 3x6 | 6006640.50448 | 2103452.44112 | 37.7560551559482 | -122.420008475637 | (37.7560551559482, -122.420008475637) | 2 | 4 | 7 | 28859 | 19 | ||
12404 | 221984 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 90 Bartlett St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2019 12:00:00 AM | 3 | 3x6 | 6006632.28944 | 2103594.72205 | 37.7564453636852 | -122.420046982776 | (37.7564453636852, -122.420046982776) | 2 | 4 | 7 | 28859 | 19 | ||
15466 | 221986 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 90 Bartlett St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006634.40739 | 2103532.54351 | 37.7562747551033 | -122.420035245751 | (37.7562747551033, -122.420035245751) | 2 | 4 | 7 | 28859 | 19 | |||
16852 | 226339 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 41 Bartlett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2019 12:00:00 AM | 3 | 3x6 | 6006685.94494 | 2103496.44851 | 37.7561785501259 | -122.419854449622 | (37.7561785501259, -122.419854449622) | 2 | 4 | 7 | 28859 | 19 | ||
17855 | 226341 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 41 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2019 12:00:00 AM | 3 | 3x6 | 6006689.89697 | 2103411.79064 | 37.7559463217857 | -122.41983477518 | (37.7559463217857, -122.41983477518) | 2 | 4 | 7 | 28859 | 19 | ||
18827 | 226337 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 41 Bartlett St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2019 12:00:00 AM | 3 | 3x6 | 6006682.98669 | 2103529.00936 | 37.7562677880488 | -122.419866990691 | (37.7562677880488, -122.419866990691) | 2 | 4 | 7 | 28859 | 19 | ||
26324 | 222004 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3027 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009328.85625 | 2101572.82594 | 37.7510452504544 | -122.410578493127 | (37.7510452504544, -122.410578493127) | 2 | 4 | 7 | 28859 | 19 | |||
32877 | 86709 | Permitted Site 7 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3027 25th St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | Permit Number 49351 | 6009354 | 2101579 | 37.7510636126747 | -122.410491979069 | (37.7510636126747, -122.410491979069) | 2 | 4 | 7 | 28859 | 19 | |||
38669 | 246752 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 182 Ripley St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 6ft | 6009207 | 2099076 | 37.7441826866665 | -122.410823565841 | (37.7441826866665, -122.410823565841) | 2 | 7 | 7 | 28859 | 2 | |||
39896 | 35389 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 779 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 13 | 9x3 | Permit Number 38843 | 6011312.83562 | 2104732.123 | 37.7598310126183 | -122.403939953189 | (37.7598310126183, -122.403939953189) | 10 | 3 | 8 | 28856 | 29 |
40110 | 18678 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 145 Richardson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5999202.78609 | 2119633.74554 | 37.8000630027522 | -122.446894823333 | (37.8000630027522, -122.446894823333) | 13 | 9 | 1 | 57 | 17 | |||
44399 | 222007 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 2 Sharon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003834.24271 | 2107055.63847 | 37.7657901686967 | -122.429970480866 | (37.7657901686967, -122.429970480866) | 8 | 4 | 5 | 28862 | 3 | |||
44544 | 86706 | Permitted Site 7 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3027 25th St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | Permit Number 49351 | 6009354 | 2101579 | 37.7510636126747 | -122.410491979069 | (37.7510636126747, -122.410491979069) | 2 | 4 | 7 | 28859 | 19 | |||
45381 | 221991 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 90 Bartlett St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006643.29491 | 2103405.27783 | 37.755925813651 | -122.419995478603 | (37.755925813651, -122.419995478603) | 2 | 4 | 7 | 28859 | 19 | |||
52785 | 48529 | Permitted Site 7 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3573-3575 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772739 | 6005786.36751364 | 2104881.42238446 | 37.7599306452178 | -122.423063935166 | (37.7599306452178, -122.423063935166) | 2 | 4 | 5 | 28859 | 19 |
57082 | 187973 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 1814 Illinois St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6016258.63636 | 2100595.19225 | 37.7487469466117 | -122.386546230235 | (37.7487469466117, -122.386546230235) | 10 | 3 | 8 | 58 | 1 | |||
60122 | 255606 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 343 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006752 | 2104119 | 37.7578916537479 | -122.419670178038 | (37.7578916537479, -122.419670178038) | 2 | 4 | 7 | 28859 | 19 | ||||
60450 | 222000 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3228 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008990.89387 | 2099875.05799 | 37.7463646038448 | -122.411627262689 | (37.7463646038448, -122.411627262689) | 2 | 7 | 7 | 28859 | 2 | |||
64579 | 86705 | Permitted Site 7 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3027 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | 3x3 | Permit Number 49351 | 6009354 | 2101579 | 37.7510636126747 | -122.410491979069 | (37.7510636126747, -122.410491979069) | 2 | 4 | 7 | 28859 | 19 | ||
65293 | 221998 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 171 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2017 12:00:00 AM | 3 | Width 3ft | 6005231.98236 | 2103978.92567 | 37.7574213016572 | -122.42491707608 | (37.7574213016572, -122.42491707608) | 2 | 4 | 5 | 28859 | 19 | ||
66189 | 66551 | Permitted Site 7 | Albizia julibrissin :: Mimosa Silk Tree 199 | 171 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | Permit Number 29734 | 6005203.58536905 | 2103971.32974572 | 37.757398840996 | -122.42501474382 | (37.757398840996, -122.42501474382) | 2 | 4 | 5 | 28859 | 19 | ||
68423 | 175231 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3500 Great Hwy | 7 | Median : | Tree | Private 2 | 6 | Width 0ft | 5982272.29331 | 2092808.76139 | 37.7254274926665 | -122.503492363109 | (37.7254274926665, -122.503492363109) | 1 | 8 | 4 | 14 | ||||
68642 | 84948 | Permitted Site 7 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3027 25th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | 3x3 | Permit Number 49351 | 6009354 | 2101579 | 37.7510636126747 | -122.410491979069 | (37.7510636126747, -122.410491979069) | 2 | 4 | 7 | 28859 | 19 | ||
71209 | 187972 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 75 Bridgeview Dr | 1 | : | Tree | Private 2 | 1 | Width 2ft | 6013703.38589 | 2095554.57798 | 37.7347646876257 | -122.395029332752 | (37.7347646876257, -122.395029332752) | 10 | 3 | 8 | 58 | 1 | |||
75725 | 66550 | Permitted Site 7 | Albizia julibrissin :: Mimosa Silk Tree 199 | 190 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | Permit Number 29733 | 6005076.47983531 | 2104016.35626613 | 37.757515292561 | -122.425457529818 | (37.757515292561, -122.425457529818) | 2 | 4 | 5 | 28859 | 19 | ||
78442 | 221992 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 990 Treat Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008580.26811 | 2102888.63865 | 37.7546161785976 | -122.413260233669 | (37.7546161785976, -122.413260233669) | 2 | 4 | 7 | 28859 | 19 | |||
83602 | 86707 | Permitted Site 7 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3027 25th St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | Permit Number 49351 | 6009354 | 2101579 | 37.7510636126747 | -122.410491979069 | (37.7510636126747, -122.410491979069) | 2 | 4 | 7 | 28859 | 19 | |||
84303 | 221987 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 90 Bartlett St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006637.6448 | 2103499.45975 | 37.7561840971364 | -122.42002170194 | (37.7561840971364, -122.42002170194) | 2 | 4 | 7 | 28859 | 19 | |||
84521 | 221993 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 990 Treat Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008581.63371 | 2102847.3466 | 37.7545028766297 | -122.413252591246 | (37.7545028766297, -122.413252591246) | 2 | 4 | 7 | 28859 | 19 | |||
87055 | 175232 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3500 Great Hwy | 20 | Median : | Tree | Private 2 | 5 | Width 0ft | 5982361.97802 | 2092682.20586 | 37.7250852772585 | -122.503172970672 | (37.7250852772585, -122.503172970672) | 1 | 8 | 4 | 14 | ||||
87686 | 221990 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 90 Bartlett St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006641.79503 | 2103432.2247 | 37.7559997190345 | -122.420002577883 | (37.7559997190345, -122.420002577883) | 2 | 4 | 7 | 28859 | 19 | |||
89372 | 221995 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 898 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6009908.08739 | 2104028.96096 | 37.7578217059317 | -122.408748702814 | (37.7578217059317, -122.408748702814) | 2 | 4 | 7 | 28859 | 19 | |||
99735 | 221988 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 90 Bartlett St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006638.42684 | 2103473.96579 | 37.7561141406682 | -122.420017188263 | (37.7561141406682, -122.420017188263) | 2 | 4 | 7 | 28859 | 19 | |||
100354 | 222005 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3027 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009336.22722 | 2101572.67544 | 37.7510452504581 | -122.410552992838 | (37.7510452504581, -122.410552992838) | 2 | 4 | 7 | 28859 | 19 | |||
105631 | 221983 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 90 Bartlett St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006631.91711 | 2103614.748 | 37.75650032934 | -122.420049691544 | (37.75650032934, -122.420049691544) | 2 | 4 | 7 | 28859 | 19 | |||
106372 | 221982 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 90 Bartlett St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006629.08969 | 2103642.36342 | 37.7565759956004 | -122.420061429494 | (37.7565759956004, -122.420061429494) | 2 | 4 | 7 | 28859 | 19 | |||
106811 | 226805 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 73 Collingwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002033.70901 | 2105453.81418 | 37.7612898163989 | -122.436083499265 | (37.7612898163989, -122.436083499265) | 15 | 4 | 5 | 28862 | 3 | |||
109588 | 204748 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 280 Joost Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6000177.43378 | 2094973.56241 | 37.7324079251883 | -122.441751381134 | (37.7324079251883, -122.441751381134) | 9 | 7 | 5 | 63 | 40 | |||
111052 | 222002 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3027 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009308.24757 | 2101572.23402 | 37.7510424697477 | -122.410649718515 | (37.7510424697477, -122.410649718515) | 2 | 4 | 7 | 28859 | 19 | |||
111373 | 86708 | Permitted Site 7 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3027 25th St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | Permit Number 49351 | 6009354 | 2101579 | 37.7510636126747 | -122.410491979069 | (37.7510636126747, -122.410491979069) | 2 | 4 | 7 | 28859 | 19 | |||
115465 | 221996 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 899 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009946.78477 | 2104029.504 | 37.7578253643707 | -122.408614908869 | (37.7578253643707, -122.408614908869) | 2 | 4 | 7 | 28859 | 19 | |||
123699 | 36587 | Permitted Site 7 | Albizia julibrissin :: Mimosa Silk Tree 199 | 1281 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42198 | 6009541.01315612 | 2101724.44316629 | 37.7514734497093 | -122.409855531474 | (37.7514734497093, -122.409855531474) | 2 | 4 | 7 | 28859 | 19 | ||
123779 | 226449 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3070 23rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008539 | 2102800 | 37.7543704799177 | -122.41339668212 | (37.7543704799177, -122.41339668212) | 2 | 4 | 7 | 28859 | 19 | |||
125182 | 175229 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3500 Great Hwy | 4 | Median : | Tree | Private 2 | 6 | Width 0ft | 5982196.22083 | 2092858.10261 | 37.725558497802 | -122.503758986902 | (37.725558497802, -122.503758986902) | 1 | 8 | 4 | 14 | ||||
127567 | 175230 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3500 Great Hwy | 6 | Median : | Tree | Private 2 | 15 | Width 0ft | 5982256.13934 | 2092818.41679 | 37.7254530540961 | -122.503548919661 | (37.7254530540961, -122.503548919661) | 1 | 8 | 4 | 14 | ||||
130594 | 221980 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 90 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006626.67847 | 2103690.249 | 37.7567073424829 | -122.420073166564 | (37.7567073424829, -122.420073166564) | 2 | 4 | 7 | 28859 | 19 | |||
136131 | 106879 | Undocumented 4 | Albizia julibrissin :: Mimosa Silk Tree 199 | 180X SAN MARCOS AVE | 2 | Median : Cutout | Tree | Private 2 | DPW | 6 | 5993452.8 | 2100406.9 | 37.7469410536635 | -122.465394372338 | (37.7469410536635, -122.465394372338) | 1 | 8 | 4 | 29491 | 40 | |||
143863 | 43308 | Permitted Site 7 | Albizia julibrissin :: Mimosa Silk Tree 199 | 731 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43074 | 6011298.37452427 | 2104952.13824403 | 37.7604343174493 | -122.404005450683 | (37.7604343174493, -122.404005450683) | 10 | 3 | 8 | 28856 | 29 | ||
146167 | 221997 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3573 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005789.27055 | 2104883.87542 | 37.7599375444968 | -122.423054069317 | (37.7599375444968, -122.423054069317) | 2 | 4 | 5 | 28859 | 19 | |||
150515 | 222003 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 3027 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009319.31004 | 2101572.27114 | 37.751043191894 | -122.410611465844 | (37.751043191894, -122.410611465844) | 2 | 4 | 7 | 28859 | 19 | |||
160175 | 222001 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 410 Valley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 2ft | 6003238.10095 | 2099234.27884 | 37.7442807928159 | -122.431474001633 | (37.7442807928159, -122.431474001633) | 2 | 7 | 5 | 63 | 22 | |||
166160 | 222006 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 638 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002365.46429 | 2100063.19063 | 37.7465072929931 | -122.434550646215 | (37.7465072929931, -122.434550646215) | 2 | 7 | 5 | 63 | 22 | |||
171281 | 221999 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 190 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005095.3438 | 2104013.90235 | 37.7575096204881 | -122.425392115964 | (37.7575096204881, -122.425392115964) | 2 | 4 | 5 | 28859 | 19 | |||
175539 | 63482 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 1716 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1990 12:00:00 AM | 8 | Permit Number 29232 | 6014515.85849 | 2094870.77995 | 37.7329322641077 | -122.392172506761 | (37.7329322641077, -122.392172506761) | 10 | 3 | 8 | 58 | 1 | |
178713 | 57071 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 930 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 12 | 6.5x9 | Permit Number 14337 | 6015214.98286 | 2104265.67951 | 37.7587674959327 | -122.390411633305 | (37.7587674959327, -122.390411633305) | 10 | 3 | 8 | 28856 | 29 | |
180399 | 221994 | DPW Maintained 1 | Albizia julibrissin :: Mimosa Silk Tree 199 | 898 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009905.4747 | 2104068.34627 | 37.7579297027976 | -122.408760517176 | (37.7579297027976, -122.408760517176) | 2 | 4 | 7 | 28859 | 19 |
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) );