trees
62 rows where Fire Prevention Districts = 10 and qSpecies_id = 95
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
860 | 9301 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1 Mansell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6011832.70408 | 2090706.21234 | 37.7213478755834 | -122.401156387751 | (37.7213478755834, -122.401156387751) | 10 | 7 | 8 | 309 | 28 | |||
1102 | 64618 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 355 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29568 | 6008648.33494852 | 2097105.55483154 | 37.7387409360622 | -122.412616048547 | (37.7387409360622, -122.412616048547) | 10 | 7 | 7 | 28859 | 2 | ||
2767 | 49750 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 310 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 2 | Permit Number 46548 | 6011291.8839 | 2088250.88482 | 37.714575859155 | -122.402853264575 | (37.714575859155, -122.402853264575) | 10 | 7 | 8 | 309 | 39 | |
11959 | 80608 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1525 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6013013.8761 | 2105640.89968 | 37.7624212021999 | -122.398120604778 | (37.7624212021999, -122.398120604778) | 10 | 3 | 8 | 28856 | 29 | |||
15032 | 194567 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 382 Texas St | 2 | : | Tree | Private 2 | 13 | Width 3ft | 6013743.43847 | 2105323.69355 | 37.7615908320593 | -122.39557507463 | (37.7615908320593, -122.39557507463) | 10 | 3 | 8 | 28856 | 29 | |||
15534 | 80384 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 10 Bridgeview Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6014069.48963 | 2095395.06223 | 37.7343470415729 | -122.393752415043 | (37.7343470415729, -122.393752415043) | 10 | 3 | 8 | 58 | 1 | |||
20766 | 84183 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 496 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50711 | 6010074.8980178 | 2089472.05898173 | 37.7178609244136 | -122.407145708761 | (37.7178609244136, -122.407145708761) | 10 | 7 | 8 | 309 | 39 | ||
26580 | 194561 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 999 Kansas St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 6011649.57806 | 2103809.76096 | 37.7573172186375 | -122.402710453142 | (37.7573172186375, -122.402710453142) | 10 | 3 | 8 | 28856 | 29 | ||||
30717 | 194558 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2301 19th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6010916.08581 | 2105050.31946 | 37.7606825347817 | -122.405334531886 | (37.7606825347817, -122.405334531886) | 10 | 3 | 8 | 28856 | 29 | ||||
34265 | 3767 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1074 Carolina St | 5 | Median : Cutout | Tree | DPW 1 | 6 | 18 | 6012456.6037355 | 2102966.9856684 | 37.7550481677782 | -122.399860245008 | (37.7550481677782, -122.399860245008) | 10 | 3 | 8 | 28856 | 29 | |||
34766 | 62075 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 640 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1985 12:00:00 AM | Permit Number 22157 | 6013257.98331127 | 2104095.18342465 | 37.7581905974819 | -122.397167930647 | (37.7581905974819, -122.397167930647) | 10 | 3 | 8 | 28856 | 29 | ||
35422 | 178378 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Mansell St | 20 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6010770.98545 | 2090436.86466 | 37.7205490141188 | -122.404807517448 | (37.7205490141188, -122.404807517448) | 10 | 7 | 7 | 309 | 28 | |||
38101 | 194563 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 707 Kansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 1ft | 6011584.56898 | 2105045.25921 | 37.7607059927056 | -122.403022180623 | (37.7607059927056, -122.403022180623) | 10 | 3 | 8 | 28856 | 29 | |||
39183 | 194568 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1790 23rd St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6013278.79656 | 2102907.44302 | 37.7549304790786 | -122.397012671508 | (37.7549304790786, -122.397012671508) | 10 | 3 | 8 | 28856 | 29 | ||||
43700 | 194557 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 900x Carolina St | 69 | Median : Yard | Tree | DPW 1 | 11 | 6012516.26815 | 2102828.89594 | 37.7546723295715 | -122.399644211933 | (37.7546723295715, -122.399644211933) | 10 | 3 | 8 | 28856 | 29 | ||||
43998 | 49749 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 310 Campbell Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | Permit Number 46548 | 6011339.97378405 | 2088277.54861548 | 37.7146517576713 | -122.402688919521 | (37.7146517576713, -122.402688919521) | 10 | 7 | 8 | 309 | 39 | ||
45005 | 67586 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 320 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31151 | 6014299.12968665 | 2105631.25303268 | 37.7624662173131 | -122.393674678003 | (37.7624662173131, -122.393674678003) | 10 | 3 | 8 | 28856 | 29 | ||
45334 | 101849 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1001X Rhode Island St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 8 | 3x3 | 6011941.50663 | 2103634.1121 | 37.7568512205105 | -122.401688497731 | (37.7568512205105, -122.401688497731) | 10 | 3 | 8 | 28856 | 29 | |||
47123 | 62860 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 120 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1986 12:00:00 AM | Permit Number 23228 | 6008642.60634648 | 2097995.12131542 | 37.7411831693847 | -122.41269872582 | (37.7411831693847, -122.41269872582) | 10 | 7 | 7 | 28859 | 2 | ||
49268 | 194554 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1525 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6013041.39469 | 2105640.60809 | 37.76242193426 | -122.398025407042 | (37.76242193426, -122.398025407042) | 10 | 3 | 8 | 28856 | 29 | |||
50376 | 194569 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2170 Revere Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6012070.84581 | 2096680.20048 | 37.7377644932337 | -122.400752672218 | (37.7377644932337, -122.400752672218) | 10 | 3 | 8 | 58 | 1 | ||||
53354 | 49751 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 310 Campbell Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 2 | Permit Number 46548 | 6011264.41643 | 2088242.20355 | 37.7145504883813 | -122.402947593582 | (37.7145504883813, -122.402947593582) | 10 | 7 | 8 | 309 | 39 | |
53794 | 3769 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1098 Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.399831953417 | (37.754754478768, -122.399831953417) | 10 | 3 | 8 | 28856 | 29 | |||
54105 | 194555 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 9 Southern Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012324.08252 | 2103973.55648 | 37.7578046017164 | -122.400389241774 | (37.7578046017164, -122.400389241774) | 10 | 3 | 8 | 28856 | 29 | |||
54310 | 62847 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 104 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1986 12:00:00 AM | Permit Number 23215 | 6008648.09339025 | 2098061.22702833 | 37.7413649891271 | -122.412684425679 | (37.7413649891271, -122.412684425679) | 10 | 7 | 7 | 28859 | 2 | ||
56599 | 61202 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 100 Augusta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31589 | 6011219.14011918 | 2095497.57320599 | 37.734469707782 | -122.403614262052 | (37.734469707782, -122.403614262052) | 10 | 3 | 8 | 58 | 1 | ||
66833 | 194572 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 16 Waterville St | 1 | : | Tree | Private 2 | 7 | Width 1ft | 6011439.22525 | 2096039.9768 | 37.7359713251222 | -122.402891486647 | (37.7359713251222, -122.402891486647) | 10 | 3 | 8 | 58 | 1 | |||
67602 | 37789 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 301 Hamilton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2002 12:00:00 AM | 5 | Permit Number 45187 | 6009352.7648 | 2092869.00605 | 37.7271477905118 | -122.409881473561 | (37.7271477905118, -122.409881473561) | 10 | 3 | 7 | 309 | 28 | ||
74668 | 178379 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010067.80159 | 2089489.05977 | 37.717907207937 | -122.407171435816 | (37.717907207937, -122.407171435816) | 10 | 7 | 8 | 309 | 39 | |||
77888 | 33924 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1515 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1997 12:00:00 AM | Permit Number 37890 | 6013177.07893091 | 2105178.79303275 | 37.761161447817 | -122.39752373182 | (37.761161447817, -122.39752373182) | 10 | 3 | 8 | 28856 | 29 | ||
79998 | 64527 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1411 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1988 12:00:00 AM | Permit Number 25409 | 6016035.70677774 | 2094698.28418833 | 37.7325428963772 | -122.386905924583 | (37.7325428963772, -122.386905924583) | 10 | 3 | 8 | 58 | 1 | ||
80139 | 233519 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 899 Hampshire St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6010216.48713 | 2104106.2032 | 37.7580510645138 | -122.407687569327 | (37.7580510645138, -122.407687569327) | 10 | 4 | 7 | 28859 | 19 | |||
81777 | 194562 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 889 Vermont St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6011315.22024 | 2104197.07336 | 37.7583620186233 | -122.40389405447 | (37.7583620186233, -122.40389405447) | 10 | 3 | 8 | 28856 | 29 | ||||
82893 | 178377 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Mansell St | 18 | Median : Cutout | Tree | DPW 1 | 23 | Width 0ft | 6010782.26263 | 2090442.44739 | 37.7205649734793 | -122.404768928441 | (37.7205649734793, -122.404768928441) | 10 | 7 | 7 | 309 | 28 | |||
85921 | 194565 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 601 Rhode Island St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6011831.4934 | 2105538.22231 | 37.7620733453319 | -122.402202834406 | (37.7620733453319, -122.402202834406) | 10 | 3 | 8 | 28856 | 29 | |||
88468 | 61214 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 141 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1983 12:00:00 AM | Permit Number 21082 | 6011231.36543014 | 2095904.87727488 | 37.7355887616193 | -122.403600642676 | (37.7355887616193, -122.403600642676) | 10 | 3 | 8 | 58 | 1 | ||
89342 | 61200 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1745 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1983 12:00:00 AM | Permit Number 21066 | 6011201.29999643 | 2095204.84432988 | 37.7336649394432 | -122.403655351863 | (37.7336649394432, -122.403655351863) | 10 | 3 | 8 | 58 | 1 | ||
93059 | 49752 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 310 Campbell Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 2 | Permit Number 46548 | 6011250.71045 | 2088239.22111 | 37.7145415338455 | -122.402994757601 | (37.7145415338455, -122.402994757601) | 10 | 7 | 8 | 309 | 39 | |
95452 | 61216 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 155 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1983 12:00:00 AM | Permit Number 21085 | 6011236.78109112 | 2095805.55602058 | 37.7353163489665 | -122.403574932778 | (37.7353163489665, -122.403574932778) | 10 | 3 | 8 | 58 | 1 | ||
95493 | 100209 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 701 Rhode Island St | 1 | Front Yard : Yard | Tree | Private 2 | 10 | Permit Number 769013 | 6011855.86556 | 2105057.10212 | 37.7607536567646 | -122.402084714731 | (37.7607536567646, -122.402084714731) | 10 | 3 | 8 | 28856 | 29 | |||
100685 | 61788 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1269 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1985 12:00:00 AM | Permit Number 21810 | 6011996.7545231 | 2102487.05036532 | 37.7537047233984 | -122.401416818367 | (37.7537047233984, -122.401416818367) | 10 | 3 | 8 | 28856 | 29 | ||
105175 | 194559 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2301 19th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6010925.71901 | 2105051.26279 | 37.7606856635422 | -122.405301281245 | (37.7606856635422, -122.405301281245) | 10 | 3 | 8 | 28856 | 29 | ||||
113548 | 194571 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 10 Bridgeview Dr | 3 | : | Tree | Private 2 | 3 | Width 2ft | 6014067.17218 | 2095407.62951 | 37.7343814199646 | -122.393761306632 | (37.7343814199646, -122.393761306632) | 10 | 3 | 8 | 58 | 1 | |||
124004 | 194560 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2045 19th St | 1 | Side Yard : Yard | Tree | Private 2 | 6 | Width 5ft | 6011621.05801 | 2105090.22678 | 37.7608315011953 | -122.402899143494 | (37.7608315011953, -122.402899143494) | 10 | 3 | 8 | 28856 | 29 | |||
124879 | 194570 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 10 Bridgeview Dr | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6014071.17827 | 2095379.66213 | 37.7343048498944 | -122.393745499263 | (37.7343048498944, -122.393745499263) | 10 | 3 | 8 | 58 | 1 | |||
126262 | 233520 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 899 Hampshire St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6010216.38194 | 2104115.77543 | 37.7580773418214 | -122.407688608045 | (37.7580773418214, -122.407688608045) | 10 | 4 | 7 | 28859 | 19 | |||
127547 | 178392 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 29 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010751.14458 | 2093820.65833 | 37.7298390998841 | -122.405114245623 | (37.7298390998841, -122.405114245623) | 10 | 3 | 7 | 309 | 28 | |||
129496 | 255714 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 618x Mendell St | 9 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 781846 | 6016376 | 2097269 | 37.7396204009215 | -122.385908564927 | (37.7396204009215, -122.385908564927) | 10 | 3 | 8 | 58 | 1 | |||
130851 | 194574 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 6 Richards Cir | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6016320.68314 | 2095812.692 | 37.7356186118941 | -122.385998338957 | (37.7356186118941, -122.385998338957) | 10 | 3 | 8 | 58 | 1 | |||
132593 | 194564 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 609 Rhode Island St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6011831.61027 | 2105516.61152 | 37.7620140134443 | -122.402200910751 | (37.7620140134443, -122.402200910751) | 10 | 3 | 8 | 28856 | 29 | |||
138139 | 49755 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1143 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 5 | Permit Number 46551 | 6011336.45006 | 2089464.63362 | 37.7179110561333 | -122.402784534778 | (37.7179110561333, -122.402784534778) | 10 | 7 | 8 | 309 | 39 | |
139809 | 67527 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1190 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31065 | 6014447.49903376 | 2104834.36670867 | 37.7602863840457 | -122.393105757767 | (37.7602863840457, -122.393105757767) | 10 | 3 | 8 | 28856 | 29 | ||
146940 | 3770 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1098 Carolina St | 3 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.399831953417 | (37.754754478768, -122.399831953417) | 10 | 3 | 8 | 28856 | 29 | |||
149939 | 60369 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1435 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19947 | 6015750.16258389 | 2094570.92480778 | 37.7321773784731 | -122.387884244628 | (37.7321773784731, -122.387884244628) | 10 | 3 | 8 | 58 | 1 | ||
150950 | 233521 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 899 Hampshire St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6010216.52212 | 2104122.65134 | 37.7580962293748 | -122.407688608051 | (37.7580962293748, -122.407688608051) | 10 | 4 | 7 | 28859 | 19 | |||
154620 | 122471 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 400 Missouri St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 7x6 | 6013475.65456 | 2105166.78328 | 37.7611450920924 | -122.396490237357 | (37.7611450920924, -122.396490237357) | 10 | 3 | 8 | 28856 | 29 | |||
155272 | 194566 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 601 Rhode Island St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6011830.82796 | 2105546.54689 | 37.7620961656287 | -122.402205721219 | (37.7620961656287, -122.402205721219) | 10 | 3 | 8 | 28856 | 29 | |||
157025 | 37788 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 301 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2003 12:00:00 AM | 5 | Permit Number 46497 | 6009357.10808 | 2092858.09097 | 37.7271180634226 | -122.409865688662 | (37.7271180634226, -122.409865688662) | 10 | 3 | 7 | 309 | 28 | ||
164552 | 194556 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 9 Southern Heights Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6012370.12074 | 2103943.11707 | 37.7577235889979 | -122.400227883634 | (37.7577235889979, -122.400227883634) | 10 | 3 | 8 | 28856 | 29 | |||
166566 | 62573 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 801 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1986 12:00:00 AM | Permit Number 22776 | 6011595.8787413 | 2104633.73265 | 37.7595766638959 | -122.402954119848 | (37.7595766638959, -122.402954119848) | 10 | 3 | 8 | 28856 | 29 | ||
167584 | 60395 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1498 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19975 | 6015454.39806509 | 2094856.49905074 | 37.7329451185448 | -122.388926707993 | (37.7329451185448, -122.388926707993) | 10 | 3 | 8 | 58 | 1 | ||
180526 | 67545 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1015 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 3x3 | Permit Number 31091 | 6012211.61416229 | 2103662.25645514 | 37.7569435678624 | -122.400756337014 | (37.7569435678624, -122.400756337014) | 10 | 3 | 8 | 28856 | 29 |
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) );