trees
161 rows where qSpecies_id = 253 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3186 | 83807 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1401 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 4x4 | 6008437.72882 | 2117343.11767 | 37.7942967602293 | -122.414776076964 | (37.7942967602293, -122.414776076964) | 5 | 1 | 10 | 28858 | 21 | ||
| 7722 | 83808 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1401 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008436.54839 | 2117356.49629 | 37.7943334283003 | -122.414781108676 | (37.7943334283003, -122.414781108676) | 5 | 1 | 10 | 28858 | 21 | |||
| 10402 | 83809 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1401 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008435.07794 | 2117371.48968 | 37.7943745138361 | -122.414787258234 | (37.7943745138361, -122.414787258234) | 5 | 1 | 10 | 28858 | 21 | |||
| 11941 | 83812 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1401 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008431.92619 | 2117409.97039 | 37.7944799952977 | -122.414800888362 | (37.7944799952977, -122.414800888362) | 5 | 1 | 10 | 28858 | 21 | |||
| 12372 | 83811 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1401 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008432.33492 | 2117395.35869 | 37.7944398981349 | -122.414798439505 | (37.7944398981349, -122.414798439505) | 5 | 1 | 10 | 28858 | 21 | |||
| 17124 | 83810 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1401 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008433.54799 | 2117383.58824 | 37.7944076475381 | -122.414793408706 | (37.7944076475381, -122.414793408706) | 5 | 1 | 10 | 28858 | 21 | |||
| 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 | |||
| 25650 | 91526 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 350 Kansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52129 | 6011427.22856 | 2106717.22438 | 37.7652880466199 | -122.403683998044 | (37.7652880466199, -122.403683998044) | 8 | 3 | 8 | 28853 | 20 | |
| 35851 | 201922 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 251 Elmira St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6011261.04494 | 2095313.52089 | 37.7339666796233 | -122.40345643809 | (37.7339666796233, -122.40345643809) | 10 | 3 | 8 | 58 | 1 | |||
| 40955 | 188821 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1360 Rhode Island St | 2 | : | Tree | Private 2 | 6 | Width 4ft | 6011964.42006 | 2102037.47464 | 37.7524684824455 | -122.40149704467 | (37.7524684824455, -122.40149704467) | 10 | 3 | 8 | 28856 | 29 | |||
| 46842 | 188813 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2005 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6011398.91522 | 2106483.38138 | 37.7646443847563 | -122.403765472117 | (37.7646443847563, -122.403765472117) | 8 | 3 | 8 | 28856 | 29 | |||
| 74371 | 49006 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 698 De Haro St | 2 | 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 | ||
| 77774 | 175568 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1053 Silver Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6007891.0439 | 2093708.22984 | 37.7293700899505 | -122.414994016859 | (37.7293700899505, -122.414994016859) | 9 | 3 | 7 | 309 | 28 | |||
| 87479 | 188820 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 542 Rhode Island St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6011747.11762 | 2105836.05521 | 37.7628864178961 | -122.402515603339 | (37.7628864178961, -122.402515603339) | 8 | 3 | 8 | 28856 | 29 | |||
| 89541 | 188822 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 634 Connecticut St | 1 | : | Tree | Private 2 | 6 | Width 4ft | 6013248.11041 | 2104140.80641 | 37.7583153186119 | -122.397205274799 | (37.7583153186119, -122.397205274799) | 10 | 3 | 8 | 28856 | 29 | |||
| 94925 | 188816 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1900 19th St | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 6012020.70996 | 2105140.34422 | 37.7609914204511 | -122.401520438745 | (37.7609914204511, -122.401520438745) | 10 | 3 | 8 | 28856 | 29 | ||||
| 96671 | 91527 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 350 Kansas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52129 | 6011428.53387 | 2106692.79066 | 37.765221030048 | -122.403677763928 | (37.765221030048, -122.403677763928) | 8 | 3 | 8 | 28853 | 20 | |
| 102985 | 188826 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 30 Apparel Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 10ft | 6011479.87001 | 2097597.73226 | 37.7402508605846 | -122.402860485238 | (37.7402508605846, -122.402860485238) | 10 | 3 | 8 | 58 | 1 | |||
| 102993 | 188825 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1888 Illinois St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6016272.37699 | 2100354.77616 | 37.7480875745024 | -122.386481953902 | (37.7480875745024, -122.386481953902) | 3 | 8 | 58 | 1 | ||||
| 105844 | 104458 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1601X Kansas St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 4 | 3x6 | 6011832.95066 | 2100589.70632 | 37.7484858887292 | -122.401849930545 | (37.7484858887292, -122.401849930545) | 10 | 3 | 8 | 58 | 1 | |||
| 115825 | 188819 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1900 19th St | 15 | Front Yard : Yard | Tree | Private 2 | 5 | 6011993.31371 | 2105140.66841 | 37.7609907819074 | -122.401615213782 | (37.7609907819074, -122.401615213782) | 10 | 3 | 8 | 28856 | 29 | ||||
| 120588 | 188827 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2147 Revere Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6012143.80671 | 2096554.59502 | 37.7374236762702 | -122.400491589125 | (37.7374236762702, -122.400491589125) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||||
| 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 | |||
| 13571 | 221244 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 3961 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004104.16813 | 2101283.01831 | 37.7499552046892 | -122.428625337904 | (37.7499552046892, -122.428625337904) | 2 | 4 | 5 | 28862 | 22 | |||
| 19623 | 89284 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 160 Vicksburg St | 3 | 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 | ||
| 27639 | 108176 | Undocumented 4 | Betula pendula :: European White Birch 253 | 308 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007706.3 | 2105989.2 | 37.7630805015474 | -122.416502273012 | (37.7630805015474, -122.416502273012) | 8 | 4 | 7 | 28859 | 19 | ||||
| 35783 | 89282 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 160 Vicksburg St | 1 | 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 | ||
| 37602 | 221245 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 317 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004327.06853 | 2102169.26146 | 37.7524012338466 | -122.427917680279 | (37.7524012338466, -122.427917680279) | 2 | 4 | 5 | 28862 | 22 | |||
| 39063 | 108970 | Undocumented 4 | Betula pendula :: European White Birch 253 | 328 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007774.7 | 2105725.6 | 37.7623605634411 | -122.416247029237 | (37.7623605634411, -122.416247029237) | 8 | 4 | 7 | 28859 | 19 | ||||
| 57572 | 221256 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 190 Storrie St | 26 | Front Yard : Yard | Tree | Private 2 | 31 | Width 3ft | 6000877.58761 | 2105376.29663 | 37.7610112226138 | -122.440076466682 | (37.7610112226138, -122.440076466682) | 15 | 4 | 5 | 28862 | 3 | |||
| 68379 | 221249 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 43 Seward St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6000871.77064 | 2104299.24068 | 37.7580535592295 | -122.440019353436 | (37.7580535592295, -122.440019353436) | 2 | 4 | 5 | 28862 | 38 | |||
| 69268 | 48967 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 3620 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/02/2002 12:00:00 AM | Permit Number 46154 | 6006101.38799392 | 2101441.68758323 | 37.7505037014367 | -122.421730108749 | (37.7505037014367, -122.421730108749) | 2 | 4 | 5 | 28859 | 19 | ||
| 70684 | 39511 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 1240 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40963 | 6003838.6793187 | 2101050.95866079 | 37.7493029945716 | -122.429526863798 | (37.7493029945716, -122.429526863798) | 2 | 4 | 5 | 28862 | 22 | ||
| 78030 | 221247 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 231 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6001129.57838 | 2104882.27953 | 37.7596691148559 | -122.439169533648 | (37.7596691148559, -122.439169533648) | 2 | 4 | 5 | 28862 | 3 | |||
| 80432 | 221253 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 190 Storrie St | 23 | Front Yard : Yard | Tree | Private 2 | 39 | Width 3ft | 6000832.84262 | 2105336.18629 | 37.7608985420563 | -122.44022834328 | (37.7608985420563, -122.44022834328) | 15 | 4 | 5 | 28862 | 3 | |||
| 86453 | 221254 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 190 Storrie St | 24 | Front Yard : Yard | Tree | Private 2 | 19 | Width 3ft | 6000848.02687 | 2105351.68108 | 37.7609419514342 | -122.440176938936 | (37.7609419514342, -122.440176938936) | 15 | 4 | 5 | 28862 | 3 | |||
| 87522 | 221250 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 382 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001780.48006 | 2103636.43597 | 37.756285346418 | -122.43682920632 | (37.756285346418, -122.43682920632) | 2 | 4 | 5 | 28862 | 3 | |||
| 90942 | 62831 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 211 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52238 | 6004171.80944378 | 2107611.92188251 | 37.7673367003875 | -122.428842571007 | (37.7673367003875, -122.428842571007) | 8 | 4 | 5 | 28862 | 3 | ||
| 107556 | 221241 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 4239 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002260.12391 | 2101180.90395 | 37.7495702894512 | -122.434994824965 | (37.7495702894512, -122.434994824965) | 2 | 4 | 5 | 28862 | 22 | |||
| 108473 | 221240 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 4428 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001150.87294 | 2101161.43289 | 37.7494537804789 | -122.438829247299 | (37.7494537804789, -122.438829247299) | 2 | 4 | 5 | 28862 | 22 | |||
| 111681 | 221252 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 190 Storrie St | 16 | Front Yard : Yard | Tree | Private 2 | 43 | Width 3ft | 6000796.34064 | 2105302.63259 | 37.7608043335649 | -122.440352180822 | (37.7608043335649, -122.440352180822) | 15 | 4 | 5 | 28862 | 3 | |||
| 114580 | 89285 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 160 Vicksburg St | 4 | 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 | ||
| 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 | ||
| 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 | |||
| 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 |
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 3488 | 221257 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 231 Upper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999509.60101 | 2106150.92789 | 37.7630601939071 | -122.444863405022 | (37.7630601939071, -122.444863405022) | 15 | 5 | 5 | 29492 | 3 | |||
| 30579 | 221234 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 100 Upper Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999851.08678 | 2106942.56431 | 37.7652533130011 | -122.443739201223 | (37.7652533130011, -122.443739201223) | 15 | 5 | 5 | 29492 | 9 | |||
| 31033 | 139003 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2099 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997824 | 2110223 | 37.774144722636 | -122.450986949191 | (37.774144722636, -122.450986949191) | 15 | 5 | 11 | 29492 | 16 | |||
| 59463 | 221258 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 415 Roosevelt Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000035.96501 | 2106651.69719 | 37.7644652074247 | -122.443078862299 | (37.7644652074247, -122.443078862299) | 15 | 5 | 5 | 28862 | 3 | |||
| 61743 | 221232 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 959 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5999208.20061 | 2106764.45721 | 37.7647275864428 | -122.445949972229 | (37.7647275864428, -122.445949972229) | 15 | 5 | 11 | 29492 | 9 | |||
| 70578 | 221259 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 415 Roosevelt Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6000035.50507 | 2106652.66281 | 37.7644678325525 | -122.443080522454 | (37.7644678325525, -122.443080522454) | 15 | 5 | 5 | 28862 | 3 | |||
| 111554 | 165644 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 50 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781268 | 5996156.88176 | 2099849.37335 | 37.7455658035362 | -122.45600365705 | (37.7455658035362, -122.45600365705) | 1 | 5 | 4 | 59 | 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 | |||
| 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 | |||
| 31900 | 122925 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2 11th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5992432.25878 | 2114882.38324 | 37.7866279691571 | -122.469977088017 | (37.7866279691571, -122.469977088017) | 11 | 6 | 1 | 54 | 11 | |||
| 51665 | 118192 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 870 34th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 5985454.65215 | 2109961.46121 | 37.7727107105884 | -122.493754809078 | (37.7727107105884, -122.493754809078) | 11 | 6 | 2 | 55 | 26 | |||
| 52150 | 122926 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2 11th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5992433.41557 | 2114874.23335 | 37.7866056586788 | -122.469972492217 | (37.7866056586788, -122.469972492217) | 11 | 6 | 1 | 54 | 11 | |||
| 52249 | 122927 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2 11th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5992434.41445 | 2114867.59859 | 37.7865874992007 | -122.469968553103 | (37.7865874992007, -122.469968553103) | 11 | 6 | 1 | 54 | 11 | |||
| 94097 | 43784 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 266 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/2010 12:00:00 AM | 3 | Permit Number 53371 | 5989347.17578 | 2113582.51161 | 37.7828800673234 | -122.480555416149 | (37.7828800673234, -122.480555416149) | 11 | 6 | 2 | 55 | 26 | |
| 96736 | 43034 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 2488 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | 4 | Permit Number 42894 | 6000712.8749 | 2114163.5032 | 37.7851293023636 | -122.441276640017 | (37.7851293023636, -122.441276640017) | 15 | 6 | 1 | 29490 | 27 | ||
| 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 | |||
| 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 | ||
| 6149 | 175566 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 35 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6005107.68038 | 2093296.81097 | 37.7280836241415 | -122.424587117508 | (37.7280836241415, -122.424587117508) | 9 | 7 | 6 | 28861 | 5 | ||||
| 6203 | 47487 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 126 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/19/2002 12:00:00 AM | 7 | 3x3 | Permit Number 45384 | 6003210.40272 | 2094437.85686 | 37.7311093473224 | -122.431227478571 | (37.7311093473224, -122.431227478571) | 9 | 7 | 5 | 28861 | 25 |
| 15717 | 221238 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 55 Bronte St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 3ft | 6009363.02974 | 2097125.97708 | 37.7388370966643 | -122.41014640214 | (37.7388370966643, -122.41014640214) | 10 | 7 | 7 | 28859 | 2 | |||
| 20428 | 246665 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 199 Ripley St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6009271.74128 | 2099145.49563 | 37.7443771363128 | -122.410604610334 | (37.7443771363128, -122.410604610334) | 2 | 7 | 7 | 28859 | 2 | |||
| 20476 | 246655 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 3351 Harrison St | 5 | Side Yard : Yard | Tree | Private 2 | 3 | 6009062.9897 | 2099201.46712 | 37.7445191158731 | -122.411330385684 | (37.7445191158731, -122.411330385684) | 2 | 7 | 7 | 28859 | 2 | ||||
| 22515 | 246669 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 199 Ripley St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6009251.14163 | 2099145.65324 | 37.7443764141382 | -122.410675851027 | (37.7443764141382, -122.410675851027) | 2 | 7 | 7 | 28859 | 2 | |||
| 30968 | 205626 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 218 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5999958.48633 | 2094391.54606 | 37.7307973661877 | -122.442466560705 | (37.7307973661877, -122.442466560705) | 9 | 7 | 4 | 63 | 40 | ||||
| 41001 | 205633 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 270 Judson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5998290.08774 | 2093572.00221 | 37.7284518524477 | -122.448175466027 | (37.7284518524477, -122.448175466027) | 9 | 7 | 4 | 28861 | 40 | ||||
| 46075 | 246666 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 199 Ripley St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6009264.591 | 2099144.5896 | 37.7443742476718 | -122.410629270636 | (37.7443742476718, -122.410629270636) | 2 | 7 | 7 | 28859 | 2 | |||
| 50004 | 221228 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1669 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6009331.56342 | 2099739.09992 | 37.7460103968577 | -122.410439663859 | (37.7460103968577, -122.410439663859) | 2 | 7 | 7 | 28859 | 2 | |||
| 55236 | 175567 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 11 Athens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6005362.50537 | 2093198.294 | 37.7278275062278 | -122.423699176384 | (37.7278275062278, -122.423699176384) | 9 | 7 | 6 | 28861 | 5 | ||||
| 55749 | 221242 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 248 Bonview St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006837.39419 | 2097609.11075 | 37.7400217852793 | -122.418913146321 | (37.7400217852793, -122.418913146321) | 2 | 7 | 7 | 28859 | 2 | |||
| 57595 | 221229 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 469 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6002951.50241 | 2098587.87741 | 37.742489676962 | -122.432418838363 | (37.742489676962, -122.432418838363) | 2 | 7 | 5 | 63 | 22 | |||
| 57782 | 246667 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 199 Ripley St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6009260.09714 | 2099144.41836 | 37.7443735255327 | -122.410644797435 | (37.7443735255327, -122.410644797435) | 2 | 7 | 7 | 28859 | 2 | |||
| 57917 | 221237 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 172 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008095.46558 | 2097810.55655 | 37.7406456710697 | -122.41457749136 | (37.7406456710697, -122.41457749136) | 2 | 7 | 7 | 28859 | 2 | |||
| 62627 | 246653 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 3351 Harrison St | 3 | Side Yard : Yard | Tree | Private 2 | 4 | 6009062.80504 | 2099192.42716 | 37.7444942837766 | -122.411330385709 | (37.7444942837766, -122.411330385709) | 2 | 7 | 7 | 28859 | 2 | ||||
| 63670 | 246664 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 199 Ripley St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6009278.25591 | 2099147.59865 | 37.7443832759831 | -122.410582232494 | (37.7443832759831, -122.410582232494) | 2 | 7 | 7 | 28859 | 2 | |||
| 80865 | 246656 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 3351 Harrison St | 6 | Side Yard : Yard | Tree | Private 2 | 3 | 6009063.73811 | 2099209.72554 | 37.7445418336512 | -122.411328381118 | (37.7445418336512, -122.411328381118) | 2 | 7 | 7 | 28859 | 2 | ||||
| 86794 | 232077 | Permitted Site 7 | Betula pendula :: European White Birch 253 | 256 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 782664 | 6006071.88671 | 2096082.49888 | 37.7357869155289 | -122.421451570943 | (37.7357869155289, -122.421451570943) | 2 | 7 | 7 | 28859 | 2 |
| 94533 | 205625 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 59 Hearst Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 6ft | 6000816.9826 | 2094321.3971 | 37.7306536500496 | -122.439493582774 | (37.7306536500496, -122.439493582774) | 9 | 7 | 4 | 63 | 40 | |||
| 99968 | 205630 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 617 Gennessee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5997440.96339 | 2095398.84681 | 37.7334193540061 | -122.451242612865 | (37.7334193540061, -122.451242612865) | 9 | 7 | 4 | 59 | 40 | ||||
| 102545 | 82352 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 195 Dublin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 13 | 3x3 | Permit Number 50648 | 6004202.82726 | 2089290.65992 | 37.7170324715383 | -122.427429950034 | (37.7170324715383, -122.427429950034) | 9 | 7 | 6 | 28861 | 5 | |
| 103470 | 32227 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 1539 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2014 12:00:00 AM | 9 | Permit Number 772963 | 6008763.03065 | 2099819.33771 | 37.7461988237316 | -122.412411252099 | (37.7461988237316, -122.412411252099) | 2 | 7 | 7 | 28859 | 2 | |
| 104638 | 175564 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 86 San Gabriel Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000983.71045 | 2093588.28288 | 37.7286501745611 | -122.438864664381 | (37.7286501745611, -122.438864664381) | 9 | 7 | 6 | 28861 | 25 | ||||
| 113157 | 246659 | DPW Maintained 1 | Betula pendula :: European White Birch 253 | 3351 Harrison St | 9 | Side Yard : Yard | Tree | Private 2 | 3 | 6009067.50483 | 2099233.31583 | 37.7446068186524 | -122.411317022686 | (37.7446068186524, -122.411317022686) | 2 | 7 | 7 | 28859 | 2 | ||||
| 117007 | 115060 | Undocumented 4 | Betula pendula :: European White Birch 253 | 26 CRESCENT AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6005316 | 2095906 | 37.735259640844 | -122.424052422112 | (37.735259640844, -122.424052422112) | 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) );