trees
161 rows where qSpecies_id = 253
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
121280 | 205629 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 714 Detroit St | 18 | Side Yard : Yard | Tree | Private 2 | 5 | 5999458.60233 | 2095454.85434 | 37.7336884554611 | -122.444271115125 | (37.7336884554611, -122.444271115125) | 9 | 7 | 4 | 63 | 40 | ||||
122014 | 205632 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 317 Staples Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5998051.80428 | 2093774.07528 | 37.7289930725494 | -122.449013770869 | (37.7289930725494, -122.449013770869) | 9 | 7 | 4 | 28861 | 40 | |||
123652 | 51462 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 185 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52416 | 6008134.54091368 | 2097771.36958265 | 37.7405402675185 | -122.414439611243 | (37.7405402675185, -122.414439611243) | 2 | 7 | 7 | 28859 | 2 | ||
124342 | 205627 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 55 Linares Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993995.91474 | 2102156.22392 | 37.7517755602042 | -122.463643285426 | (37.7517755602042, -122.463643285426) | 1 | 8 | 4 | 29491 | 40 | |||
124701 | 221239 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 207 Montcalm St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 5ft | 6010023.25186 | 2099680.69535 | 37.745888782448 | -122.40804376831 | (37.745888782448, -122.40804376831) | 2 | 7 | 7 | 28859 | 2 | |||
125870 | 246657 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 3351 Harrison St | 7 | Side Yard : Yard | Tree | Private 2 | 4 | 6009066.27187 | 2099220.25657 | 37.7445708916489 | -122.411320363658 | (37.7445708916489, -122.411320363658) | 2 | 7 | 7 | 28859 | 2 | ||||
126582 | 125718 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2640 Baker St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 5999647.29192 | 2117942.60515 | 37.7954449660715 | -122.445235012993 | (37.7954449660715, -122.445235012993) | 13 | 9 | 1 | 57 | 17 | |||
127582 | 61454 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 2099 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52238 | 6004149.19944272 | 2107648.18855863 | 37.7674350001746 | -122.428923361715 | (37.7674350001746, -122.428923361715) | 8 | 4 | 5 | 28862 | 3 | ||
127778 | 114100 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 21x ACEVEDO AVE | 1 | Front Yard : Yard | Tree | Private 2 | 10 | 5988027 | 2090598 | 37.7196939458216 | -122.48343711114 | (37.7196939458216, -122.48343711114) | 1 | 8 | 4 | 64 | 14 | ||||
130019 | 188818 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1900 19th St | 14 | Front Yard : Yard | Tree | Private 2 | 5 | 6012000.48421 | 2105138.69901 | 37.7609857744902 | -122.401590275579 | (37.7609857744902, -122.401590275579) | 10 | 3 | 8 | 28856 | 29 | ||||
131525 | 246663 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 199 Ripley St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6009284.02698 | 2099145.63944 | 37.7443782199713 | -122.410562138936 | (37.7443782199713, -122.410562138936) | 2 | 7 | 7 | 28859 | 2 | |||
132222 | 183673 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1267 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5984268.1791 | 2106557.6883 | 37.7632954325476 | -122.497607531112 | (37.7632954325476, -122.497607531112) | 1 | 8 | 3 | 56 | 35 | |||
135879 | 125717 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2640 Baker St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5999646.03344 | 2117962.09601 | 37.7954984109675 | -122.445240769556 | (37.7954984109675, -122.445240769556) | 13 | 9 | 1 | 57 | 17 | |||
136409 | 188815 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 800 19th St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6014947.0583 | 2105331.24702 | 37.7616784485163 | -122.391412738808 | (37.7616784485163, -122.391412738808) | 10 | 3 | 8 | 28856 | 29 | |||
136797 | 205628 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 45 Linares Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5993975.22744 | 2102175.9193 | 37.7518284466452 | -122.463716253701 | (37.7518284466452, -122.463716253701) | 1 | 8 | 4 | 29491 | 40 | |||
137020 | 249673 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2400 Baker St | 5 | Front Yard : Yard | Tree | Private 2 | 4 | 5999744.88786 | 2117135.23947 | 37.7932337237968 | -122.444839251946 | (37.7932337237968, -122.444839251946) | 13 | 9 | 1 | 57 | 27 | ||||
137222 | 188824 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1601 Kansas St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6011832.95066 | 2100589.70632 | 37.7484858887292 | -122.401849930545 | (37.7484858887292, -122.401849930545) | 10 | 3 | 8 | 58 | 1 | |||
139051 | 221231 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1415 Sanchez St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6003960.41369 | 2100001.20175 | 37.7464274979283 | -122.429031067947 | (37.7464274979283, -122.429031067947) | 2 | 7 | 5 | 63 | 22 | |||
140383 | 246652 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 3351 Harrison St | 2 | Side Yard : Yard | Tree | Private 2 | 4 | 6009060.33102 | 2099186.64179 | 37.744478259666 | -122.411338531775 | (37.744478259666, -122.411338531775) | 2 | 7 | 7 | 28859 | 2 | ||||
140451 | 205623 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1664 09th Ave | 2 | Front Yard : Yard | Tree | Private 2 | 9 | Width 6ft | 5993427.80245 | 2104143.27983 | 37.7571987518308 | -122.46575223428 | (37.7571987518308, -122.46575223428) | 1 | 8 | 4 | 56 | 12 | |||
140808 | 221236 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 794 Moultrie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007584.36725 | 2095802.33798 | 37.7351028174275 | -122.416202483569 | (37.7351028174275, -122.416202483569) | 2 | 7 | 7 | 28859 | 2 | |||
141195 | 246668 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 199 Ripley St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6009255.34183 | 2099144.38379 | 37.7443731639988 | -122.410661237926 | (37.7443731639988, -122.410661237926) | 2 | 7 | 7 | 28859 | 2 | |||
141873 | 221255 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 190 Storrie St | 25 | Front Yard : Yard | Tree | Private 2 | 38 | Width 3ft | 6000864.19638 | 2105365.81027 | 37.7609816672784 | -122.440122029029 | (37.7609816672784, -122.440122029029) | 15 | 4 | 5 | 28862 | 3 | |||
142212 | 82353 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 195 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 16 | 3x3 | Permit Number 50648 | 6004206.08009 | 2089287.93372 | 37.7170251699614 | -122.427418512461 | (37.7170251699614, -122.427418512461) | 9 | 7 | 6 | 28861 | 5 | |
146680 | 46437 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 522 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53513 | 6007833.8887996 | 2104879.83427727 | 37.7600416140087 | -122.415982420225 | (37.7600416140087, -122.415982420225) | 2 | 4 | 7 | 28859 | 19 |
147669 | 188823 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1601 Kansas St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6011832.95066 | 2100589.70632 | 37.7484858887292 | -122.401849930545 | (37.7484858887292, -122.401849930545) | 10 | 3 | 8 | 58 | 1 | |||
148894 | 182042 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1329 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5987076.1241 | 2106191.7238 | 37.7624547889055 | -122.487869010507 | (37.7624547889055, -122.487869010507) | 1 | 8 | 3 | 56 | 35 | |||
150859 | 221227 | Undocumented 4 | Betula pendula :: European White Birch 253 | 26 Crescent Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6005423.00406 | 2095885.44307 | 37.7352092369163 | -122.42368100828 | (37.7352092369163, -122.42368100828) | 2 | 7 | 7 | 28859 | 2 | |||
151606 | 49007 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 698 De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2003 12:00:00 AM | 3x3 | Permit Number 46234 | 6012086.71904348 | 2105158.36746792 | 37.7610445912521 | -122.401293407307 | (37.7610445912521, -122.401293407307) | 10 | 3 | 8 | 28856 | 29 | ||
153440 | 114037 | Undocumented 4 | Betula pendula :: European White Birch 253 | 1669 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6009356 | 2099744 | 37.7460252212812 | -122.410355511001 | (37.7460252212812, -122.410355511001) | 2 | 7 | 7 | 28859 | 2 | |||
153610 | 246654 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 3351 Harrison St | 4 | Side Yard : Yard | Tree | Private 2 | 4 | 6009056.91969 | 2099197.55038 | 37.7445080209224 | -122.411351097986 | (37.7445080209224, -122.411351097986) | 2 | 7 | 7 | 28859 | 2 | ||||
155599 | 221246 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 233 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6001130.70274 | 2104859.07812 | 37.759605473426 | -122.439163982134 | (37.759605473426, -122.439163982134) | 2 | 4 | 5 | 28862 | 3 | |||
156726 | 119928 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 3750 Anza St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 5986949.49746 | 2111884.49036 | 37.7780781472848 | -122.488725421171 | (37.7780781472848, -122.488725421171) | 11 | 6 | 2 | 55 | 26 | |||
156777 | 114101 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 21x ACEVEDO AVE | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 5988027 | 2090598 | 37.7196939458216 | -122.48343711114 | (37.7196939458216, -122.48343711114) | 1 | 8 | 4 | 64 | 14 | ||||
160652 | 89283 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 160 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/2008 12:00:00 AM | 3x3 | Permit Number 51893 | 6004103 | 2102285 | 37.7527063460416 | -122.428700795885 | (37.7527063460416, -122.428700795885) | 2 | 4 | 5 | 28862 | 22 | ||
161250 | 114073 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 18x HIGUERA AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5988029 | 2090212 | 37.7186342037977 | -122.483401916227 | (37.7186342037977, -122.483401916227) | 1 | 8 | 4 | 64 | 14 | ||||
161877 | 175562 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1665 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5998346.15362 | 2088865.15778 | 37.7155311550278 | -122.447642956778 | (37.7155311550278, -122.447642956778) | 9 | 7 | 6 | 28861 | 25 | |||
164611 | 205619 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1410 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5991815.90489 | 2105796.1223 | 37.7616439109643 | -122.471447180367 | (37.7616439109643, -122.471447180367) | 1 | 8 | 4 | 56 | 12 | |||
165674 | 221251 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 310 Liberty St | 54 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6003815.34133 | 2103923.3524 | 37.757188590406 | -122.429812419609 | (37.757188590406, -122.429812419609) | 2 | 4 | 5 | 28862 | 3 | |||
167270 | 175563 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5988277.07749 | 2089797.21556 | 37.7175097453622 | -122.482514046798 | (37.7175097453622, -122.482514046798) | 1 | 8 | 4 | 64 | 14 | ||||
168521 | 249672 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2400 Baker St | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 5999740.71389 | 2117125.7737 | 37.7932074950865 | -122.444853013365 | (37.7932074950865, -122.444853013365) | 13 | 9 | 1 | 57 | 27 | ||||
168523 | 205634 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 270 Judson Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5998287.7402 | 2093571.27681 | 37.7284497264672 | -122.448183529344 | (37.7284497264672, -122.448183529344) | 9 | 7 | 4 | 28861 | 40 | ||||
171506 | 221235 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 112 Upper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999837.49365 | 2106933.69543 | 37.7652281859523 | -122.443785579252 | (37.7652281859523, -122.443785579252) | 15 | 5 | 5 | 29492 | 9 | |||
172364 | 249669 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2400 Baker St | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 5999737.17484 | 2117101.84949 | 37.7931416035487 | -122.44486353812 | (37.7931416035487, -122.44486353812) | 13 | 9 | 1 | 57 | 27 | ||||
173574 | 246658 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 3351 Harrison St | 8 | Side Yard : Yard | Tree | Private 2 | 3 | 6009066.3858 | 2099225.83435 | 37.7445862133943 | -122.411320363668 | (37.7445862133943, -122.411320363668) | 2 | 7 | 7 | 28859 | 2 | ||||
175304 | 182707 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1825 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5988600.9285 | 2103724.0215 | 37.7557679721196 | -122.482414516683 | (37.7557679721196, -122.482414516683) | 1 | 8 | 3 | 56 | 35 | |||
175345 | 221226 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 88 Crescent Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6005769.38033 | 2095838.80012 | 37.7351007121151 | -122.422480144438 | (37.7351007121151, -122.422480144438) | 2 | 7 | 7 | 28859 | 2 | |||
176041 | 221233 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 959 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5999213.29336 | 2106736.99218 | 37.7646524651563 | -122.445930382297 | (37.7646524651563, -122.445930382297) | 15 | 5 | 11 | 29492 | 9 | |||
177012 | 201921 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 251 Elmira St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6011262.31723 | 2095298.90659 | 37.7339266228979 | -122.403451011558 | (37.7339266228979, -122.403451011558) | 10 | 3 | 8 | 58 | 1 | |||
177139 | 221243 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1240 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003838.29098 | 2101086.08552 | 37.7493994227408 | -122.429530711483 | (37.7493994227408, -122.429530711483) | 2 | 4 | 5 | 28862 | 22 | |||
178706 | 53406 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1911 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1969 12:00:00 AM | 10 | Permit Number 6305 | 6003659.05239 | 2119321.24643 | 37.7994585351485 | -122.431452119331 | (37.7994585351485, -122.431452119331) | 13 | 9 | 1 | 57 | 17 | ||
178846 | 221248 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 43 Seward St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6000867.48492 | 2104298.6748 | 37.7580517614839 | -122.440034134675 | (37.7580517614839, -122.440034134675) | 2 | 4 | 5 | 28862 | 38 | |||
180198 | 221230 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1415 Sanchez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6003960.53508 | 2099994.15866 | 37.7464081661066 | -122.42903014612 | (37.7464081661066, -122.42903014612) | 2 | 7 | 5 | 63 | 22 | |||
182478 | 56295 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 135 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1973 12:00:00 AM | 5 | Permit Number 12424 | 5993944.56899 | 2114612.22651 | 37.7859734975152 | -122.46472527724 | (37.7859734975152, -122.46472527724) | 11 | 6 | 2 | 54 | 11 | ||
184508 | 175565 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 25 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004860.30584 | 2093398.90796 | 37.7283499862525 | -122.425449562862 | (37.7283499862525, -122.425449562862) | 9 | 7 | 6 | 28861 | 5 | |||
185370 | 246651 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 3351 Harrison St | 1 | Side Yard : Yard | Tree | Private 2 | 3 | 6009062.25823 | 2099181.14023 | 37.7444632616835 | -122.411331479274 | (37.7444632616835, -122.411331479274) | 2 | 7 | 7 | 28859 | 2 | ||||
186394 | 246662 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 199 Ripley St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6009287.77432 | 2099148.06165 | 37.7443850809164 | -122.410549352377 | (37.7443850809164, -122.410549352377) | 2 | 7 | 7 | 28859 | 2 | |||
190014 | 187918 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 48 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013111.47563 | 2115056.38033 | 37.7882794108076 | -122.398443735705 | (37.7882794108076, -122.398443735705) | 12 | 2 | 9 | 28855 | 6 | |||
190346 | 188817 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1900 19th St | 11 | Front Yard : Yard | Tree | Private 2 | 6 | 6012013.68771 | 2105139.25705 | 37.7609880434929 | -122.40154464938 | (37.7609880434929, -122.40154464938) | 10 | 3 | 8 | 28856 | 29 | ||||
191700 | 16060 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 231 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2002 12:00:00 AM | 6 | 3x3 | 6000534.94715 | 2094624.24061 | 37.7314691327835 | -122.440490331957 | (37.7314691327835, -122.440490331957) | 9 | 7 | 4 | 63 | 40 | ||
192969 | 188814 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 651 Indiana St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6014938.9905 | 2105400.06463 | 37.7618669590005 | -122.391445453452 | (37.7618669590005, -122.391445453452) | 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) );