trees
8,758 rows where qSpecies_id = 16 sorted by Police Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1109 | 102184 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1840X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | 12 | 3x3 | 6003534.8 | 2115143.2 | 37.7879796472282 | -122.431583632877 | (37.7879796472282, -122.431583632877) | 13 | 9 | 11 | 29490 | 27 | ||
1147 | 131409 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2817 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6003467.33625 | 2118170.97636 | 37.796289323341 | -122.432033340382 | (37.796289323341, -122.432033340382) | 13 | 9 | 1 | 57 | 17 | |||
1237 | 35474 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/1998 12:00:00 AM | Permit Number 38887 | 6007396.82109854 | 2112616.81920427 | 37.7812609627381 | -122.418042529741 | (37.7812609627381, -122.418042529741) | 7 | 9 | 9 | 28852 | 36 | |||
1667 | 101664 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
1966 | 61296 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2360 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1986 12:00:00 AM | 9 | Permit Number 23055 | 6006748.00387 | 2119357.01746 | 37.7997313381808 | -122.420765770421 | (37.7997313381808, -122.420765770421) | 5 | 9 | 1 | 28858 | 32 | |
2422 | 80046 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2325 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6001817.74148 | 2118715.85745 | 37.7976917657091 | -122.437780314931 | (37.7976917657091, -122.437780314931) | 13 | 9 | 1 | 57 | 17 | |||
2692 | 18211 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1575 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004651.3172937 | 2114317.5621297 | 37.7857758731644 | -122.427661834419 | (37.7857758731644, -122.427661834419) | 13 | 9 | 11 | 28858 | 13 | |||
2972 | 74792 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 749 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6007023.88187 | 2113548.27609 | 37.783797519769 | -122.419398818026 | (37.783797519769, -122.419398818026) | 7 | 9 | 9 | 28858 | 36 | |||
3658 | 140493 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1340 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6003595.4388 | 2112480.2415 | 37.7806712690813 | -122.431183683552 | (37.7806712690813, -122.431183683552) | 15 | 9 | 11 | 29490 | 41 | |||
5054 | 102983 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
5931 | 7196 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 949 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003418.39077 | 2111568.89089 | 37.7781588927529 | -122.431731089816 | (37.7781588927529, -122.431731089816) | 15 | 9 | 11 | 29492 | 41 | |||
6828 | 131262 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2711 Union St | 2 | Front Yard : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 785082 | 6000010.78683 | 2118118.88771 | 37.7959497330364 | -122.443989935801 | (37.7959497330364, -122.443989935801) | 13 | 9 | 1 | 57 | 17 | ||
6869 | 51982 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2005 12:00:00 AM | Permit Number 48204 | 6007266.85815782 | 2113345.5415055 | 37.7832545419232 | -122.4185438282 | (37.7832545419232, -122.4185438282) | 7 | 9 | 9 | 28858 | 36 | |||
8148 | 7734 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3x3 | 6006417.36011 | 2111247.60822 | 37.777446266458 | -122.421333726477 | (37.777446266458, -122.421333726477) | 7 | 9 | 11 | 28852 | 10 | |||
8332 | 131472 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 280 Redwood St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006289.44845 | 2112330.99569 | 37.7804137729253 | -122.421853191093 | (37.7804137729253, -122.421853191093) | 7 | 9 | 11 | 28852 | 41 | |||
8718 | 74934 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 747 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6007018.6844 | 2113571.6653 | 37.7838614481007 | -122.419418459219 | (37.7838614481007, -122.419418459219) | 7 | 9 | 9 | 28858 | 36 | |||
9076 | 9908 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1809 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 6x6 | 6005225.98494 | 2115998.17525 | 37.7904229062421 | -122.425793311632 | (37.7904229062421, -122.425793311632) | 13 | 9 | 1 | 28858 | 27 | |||
9336 | 131379 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2990 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5999358.44425 | 2117025.78745 | 37.7929111360792 | -122.446168490398 | (37.7929111360792, -122.446168490398) | 13 | 9 | 1 | 57 | 27 | |||
9728 | 74639 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 749 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6007029.8225 | 2113512.73169 | 37.7837002581006 | -122.419375743216 | (37.7837002581006, -122.419375743216) | 7 | 9 | 9 | 28858 | 36 | |||
9864 | 102975 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
9926 | 80088 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2325 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6001799.98611 | 2118713.99662 | 37.7976856467424 | -122.437841619893 | (37.7976856467424, -122.437841619893) | 13 | 9 | 1 | 57 | 17 | |||
10186 | 250045 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6006086.73506 | 2114727.88869 | 37.7869836181338 | -122.422724857187 | (37.7869836181338, -122.422724857187) | 13 | 9 | 1 | 28858 | 41 | |||
10900 | 256098 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1776 Vallejo St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005064.21519 | 2118169.93221 | 37.7963768588038 | -122.426507729874 | (37.7963768588038, -122.426507729874) | 13 | 9 | 1 | 28858 | 17 | |||||
12499 | 101675 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
12583 | 131471 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 280 Redwood St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6006315.87363 | 2112335.20118 | 37.7804268103756 | -122.421762072675 | (37.7804268103756, -122.421762072675) | 7 | 9 | 11 | 28852 | 41 | |||
12589 | 142807 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 560 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007175.9825 | 2112820.8168 | 37.7818086588347 | -122.418820996316 | (37.7818086588347, -122.418820996316) | 7 | 9 | 9 | 28852 | 36 | |||
12713 | 131502 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Turk St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6007471.98595 | 2112970.25265 | 37.7822356356972 | -122.417807555783 | (37.7822356356972, -122.417807555783) | 7 | 9 | 9 | 28852 | 36 | |||
13710 | 41219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Mallorca Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 7 | Permit Number 41927 | 6001924.51424 | 2120048.48598 | 37.8013568843691 | -122.437506333775 | (37.8013568843691, -122.437506333775) | 13 | 9 | 1 | 57 | 17 | |
13790 | 35470 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/1998 12:00:00 AM | 7 | Permit Number 38887 | 6007482.79504 | 2112627.10573 | 37.7812940455214 | -122.417745830826 | (37.7812940455214, -122.417745830826) | 7 | 9 | 9 | 28852 | 36 | ||
15753 | 138822 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 628 IVY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004336.8563 | 2111016.0726 | 37.7766930096288 | -122.428514368993 | (37.7766930096288, -122.428514368993) | 7 | 9 | 11 | 28852 | 10 | |||
18537 | 12409 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1500 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004564.3 | 2114031.3 | 37.7849849463478 | -122.427942483992 | (37.7849849463478, -122.427942483992) | 13 | 9 | 11 | 28858 | 41 | |||
19655 | 2651 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1958 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004155.6542 | 2114999.6285 | 37.7876206064413 | -122.429425346374 | (37.7876206064413, -122.429425346374) | 13 | 9 | 11 | 29490 | 27 | |||
19769 | 139338 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1599 Post St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6004819.7275 | 2114341.955 | 37.7858523745618 | -122.427080920373 | (37.7858523745618, -122.427080920373) | 13 | 9 | 11 | 28858 | 13 | |||
19990 | 87879 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 255 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50851 | 6002250.92262 | 2121888.76212 | 37.8064283484493 | -122.436508609691 | (37.8064283484493, -122.436508609691) | 13 | 9 | 1 | 57 | 17 | |
21158 | 131408 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2775 Fillmore St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6002572.23885 | 2117636.31232 | 37.7947704880149 | -122.435092299768 | (37.7947704880149, -122.435092299768) | 13 | 9 | 1 | 29490 | 27 | |||
21229 | 131496 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6007241.99076 | 2112941.14333 | 37.7821427627223 | -122.418601173323 | (37.7821427627223, -122.418601173323) | 7 | 9 | 9 | 28852 | 36 | |||
21322 | 139784 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1561 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003293.6544 | 2113081.8534 | 37.7823060384808 | -122.432270678372 | (37.7823060384808, -122.432270678372) | 15 | 9 | 11 | 29490 | 41 | |||
23325 | 101665 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
24264 | 101666 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
24562 | 131339 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003059.47166 | 2120673.83402 | 37.8031383873936 | -122.433623598957 | (37.8031383873936, -122.433623598957) | 13 | 9 | 1 | 57 | 17 | |||
24592 | 250049 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 8 | : | Tree | Private 2 | 10 | Width 3ft | 6005972.08253 | 2114712.11265 | 37.7869338316717 | -122.423120407802 | (37.7869338316717, -122.423120407802) | 13 | 9 | 1 | 28858 | 41 | |||
24665 | 101842 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
25091 | 131498 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6007304.36965 | 2112951.80978 | 37.7821755618839 | -122.418386126541 | (37.7821755618839, -122.418386126541) | 7 | 9 | 9 | 28852 | 36 | |||
25200 | 131264 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2590 Union St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6000607.50616 | 2118250.19096 | 37.7963442782168 | -122.441934607201 | (37.7963442782168, -122.441934607201) | 13 | 9 | 1 | 57 | 17 | |||
26719 | 131327 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3401 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6000773.56958 | 2120041.75431 | 37.8012728984789 | -122.441488619015 | (37.8012728984789, -122.441488619015) | 13 | 9 | 1 | 57 | 17 | |||
27060 | 131252 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2900 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6000581.48858 | 2118260.01717 | 37.7963697757901 | -122.442025338908 | (37.7963697757901, -122.442025338908) | 13 | 9 | 1 | 57 | 17 | |||
27207 | 131247 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3044 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 6ft | 6000507.69667 | 2118799.54155 | 37.7978469617259 | -122.442319425314 | (37.7978469617259, -122.442319425314) | 13 | 9 | 1 | 57 | 17 | |||
27295 | 131421 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1800 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6004844.69174 | 2118143.74264 | 37.7962925366161 | -122.427265461332 | (37.7962925366161, -122.427265461332) | 13 | 9 | 1 | 57 | 17 | |||
27712 | 131499 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6007343.63427 | 2112952.09091 | 37.782178544034 | -122.418250308228 | (37.782178544034, -122.418250308228) | 7 | 9 | 9 | 28852 | 36 | |||
27825 | 131512 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 270 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006101.39727 | 2110910.32308 | 37.7765023443558 | -122.422402776687 | (37.7765023443558, -122.422402776687) | 7 | 9 | 11 | 28852 | 10 | |||
28504 | 63057 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 720 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1986 12:00:00 AM | 13 | Permit Number 23529 | 6003063.5407 | 2110923.6319 | 37.7763670512632 | -122.43291253384 | (37.7763670512632, -122.43291253384) | 15 | 9 | 11 | 29492 | 10 | ||
29125 | 39233 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 7 | Permit Number 40872 | 6007554.12985 | 2112694.05006 | 37.7814818725203 | -122.417503792676 | (37.7814818725203, -122.417503792676) | 7 | 9 | 9 | 28852 | 36 | ||
29870 | 2695 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2111 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/2003 12:00:00 AM | 3 | 3x3 | 6003424.2987912 | 2114891.8357248 | 37.787283200782 | -122.431947991092 | (37.787283200782, -122.431947991092) | 13 | 9 | 11 | 29490 | 27 | ||
30046 | 142809 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 580 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6007168.5268 | 2112869.7338 | 37.7819425532526 | -122.418850259969 | (37.7819425532526, -122.418850259969) | 7 | 9 | 9 | 28852 | 36 | |||
31070 | 35471 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/1998 12:00:00 AM | 6 | Permit Number 38887 | 6007305.09171 | 2112609.40179 | 37.7812354331103 | -122.418359342935 | (37.7812354331103, -122.418359342935) | 7 | 9 | 9 | 28852 | 36 | ||
31134 | 60996 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1978 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/1987 12:00:00 AM | 13 | Permit Number 24683 | 6003486.62048 | 2118994.5552 | 37.7985517514175 | -122.432025453305 | (37.7985517514175, -122.432025453305) | 13 | 9 | 1 | 57 | 17 | ||
31286 | 60135 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2260 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/1982 12:00:00 AM | 12 | Permit Number 19665 | 6003316.24478 | 2117231.87007 | 37.7937022121412 | -122.432489037634 | (37.7937022121412, -122.432489037634) | 13 | 9 | 1 | 29490 | 27 | ||
31377 | 6967 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 720 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003956.4801 | 2110455.6856 | 37.7751327920886 | -122.429790222459 | (37.7751327920886, -122.429790222459) | 7 | 9 | 11 | 29492 | 10 | |||
31497 | 131245 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2739 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6000072.61885 | 2118020.70092 | 37.79568366503 | -122.443768928311 | (37.79568366503, -122.443768928311) | 13 | 9 | 1 | 57 | 17 | |||
31560 | 131266 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2345 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001771.13648 | 2118707.72277 | 37.7976667798634 | -122.437940997677 | (37.7976667798634, -122.437940997677) | 13 | 9 | 1 | 57 | 17 | |||
31652 | 131352 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2440 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 4ft | 6003006.84582 | 2116534.31163 | 37.7917693460397 | -122.433509710612 | (37.7917693460397, -122.433509710612) | 13 | 9 | 1 | 29490 | 27 | |||
31723 | 65866 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 49 Toledo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1990 12:00:00 AM | 12 | Permit Number 28858 | 6001681.56159 | 2120025.01141 | 37.8012786136861 | -122.438345373351 | (37.8012786136861, -122.438345373351) | 13 | 9 | 1 | 57 | 17 | |
31935 | 142818 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 LARKIN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6007650.4228 | 2112555.8649 | 37.7811078670394 | -122.417160869916 | (37.7811078670394, -122.417160869916) | 7 | 9 | 9 | 28852 | 36 | |||
32257 | 7870 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1001 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006017.92474 | 2113680.12204 | 37.7841028269903 | -122.422888431641 | (37.7841028269903, -122.422888431641) | 7 | 9 | 11 | 28858 | 41 | |||
32794 | 2688 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2103 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1991 12:00:00 AM | 6 | 3X3 | 6003377.8906 | 2114832.113 | 37.7871165862827 | -122.432104286971 | (37.7871165862827, -122.432104286971) | 13 | 9 | 11 | 29490 | 27 | ||
33216 | 250048 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 7 | : | Tree | Private 2 | 9 | Width 3ft | 6005996.49093 | 2114715.62099 | 37.7869448420797 | -122.423036209646 | (37.7869448420797, -122.423036209646) | 13 | 9 | 1 | 28858 | 41 | |||
34398 | 101661 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
34849 | 131393 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2715 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002098.80212 | 2117529.9842 | 37.7944516441805 | -122.436722838085 | (37.7944516441805, -122.436722838085) | 13 | 9 | 1 | 57 | 27 | |||
34938 | 105419 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2310 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6003748.57282 | 2116457.88739 | 37.7916015595189 | -122.430937881603 | (37.7916015595189, -122.430937881603) | 13 | 9 | 1 | 29490 | 27 | ||||
34944 | 131419 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2421 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004959.50705 | 2117913.47184 | 37.7956667640765 | -122.426851768712 | (37.7956667640765, -122.426851768712) | 13 | 9 | 1 | 28858 | 27 | |||
35212 | 131274 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6001259.5494 | 2119728.7209 | 37.8004410660637 | -122.439784463083 | (37.8004410660637, -122.439784463083) | 13 | 9 | 1 | 57 | 17 | |||
35375 | 131354 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2584 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6002330.82702 | 2116440.92711 | 37.7914745581565 | -122.435842045694 | (37.7914745581565, -122.435842045694) | 13 | 9 | 1 | 29490 | 27 | |||
37174 | 7732 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3x3 | 6006424.96145 | 2111194.8411 | 37.7773018092612 | -122.421303682828 | (37.7773018092612, -122.421303682828) | 7 | 9 | 11 | 28852 | 10 | |||
37484 | 9910 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1850 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6005262.94947 | 2116061.61186 | 37.7905991760505 | -122.425669933628 | (37.7905991760505, -122.425669933628) | 13 | 9 | 1 | 28858 | 27 | |||
37719 | 81999 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50638 | 6005960.45556 | 2120727.09731 | 37.8034488081703 | -122.423588442877 | (37.8034488081703, -122.423588442877) | 5 | 9 | 1 | 28858 | 32 |
38064 | 250040 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10 Daniel Burnham Ct | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6006198.948 | 2114743.14871 | 37.7870318487916 | -122.422337709814 | (37.7870318487916, -122.422337709814) | 13 | 9 | 1 | 28858 | 41 | |||
39219 | 139785 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1560 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003300.6514 | 2113120.3366 | 37.782412100422 | -122.432249221093 | (37.782412100422, -122.432249221093) | 15 | 9 | 11 | 29490 | 41 | |||
39285 | 131475 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 440 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6007218.68142 | 2112511.52333 | 37.7809618179646 | -122.418651337495 | (37.7809618179646, -122.418651337495) | 7 | 9 | 9 | 28852 | 36 | |||
39478 | 131325 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2730 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000126.82752 | 2117963.94814 | 37.7955309286682 | -122.443577278288 | (37.7955309286682, -122.443577278288) | 13 | 9 | 1 | 57 | 17 | |||
39610 | 250046 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 5 | : | Tree | Private 2 | 10 | Width 3ft | 6006034.57515 | 2114720.06869 | 37.7869592033491 | -122.422904762956 | (37.7869592033491, -122.422904762956) | 13 | 9 | 1 | 28858 | 41 | |||
39672 | 131504 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Turk St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6007514.85335 | 2112978.98813 | 37.7822620335141 | -122.41765987271 | (37.7822620335141, -122.41765987271) | 7 | 9 | 9 | 28852 | 36 | |||
40464 | 48834 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3700X Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2002 12:00:00 AM | 3 | 3x3 | 6003107.67993 | 2121141.17951 | 37.8044243306918 | -122.43349019084 | (37.8044243306918, -122.43349019084) | 13 | 9 | 1 | 57 | 17 | ||
40814 | 33713 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 111 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37780 | 6003684.10499818 | 2108803.26479984 | 37.770580222183 | -122.430614491306 | (37.770580222183, -122.430614491306) | 15 | 9 | 11 | 29492 | 10 | |||
41438 | 131476 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 440 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6007212.91851 | 2112526.76592 | 37.7810033459715 | -122.418672355545 | (37.7810033459715, -122.418672355545) | 7 | 9 | 9 | 28852 | 36 | |||
42921 | 9907 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1809 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6005224.35314 | 2116024.07833 | 37.7904939373852 | -122.425800802087 | (37.7904939373852, -122.425800802087) | 13 | 9 | 1 | 28858 | 27 | |||
43260 | 131415 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2220 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6005082.43069 | 2117363.14058 | 37.794162643455 | -122.426387227502 | (37.794162643455, -122.426387227502) | 13 | 9 | 1 | 28858 | 27 | |||
43354 | 2705 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2125 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1981 12:00:00 AM | 6 | 3X3 | 6003127.3628 | 2114798.1705 | 37.7870091818806 | -122.432968631522 | (37.7870091818806, -122.432968631522) | 13 | 9 | 11 | 29490 | 27 | ||
43656 | 21611 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1535X Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1991 12:00:00 AM | 12 | 4X4 | 6005253.1510352 | 2114747.1129548 | 37.786989337098 | -122.425610240694 | (37.786989337098, -122.425610240694) | 13 | 9 | 11 | 28858 | 13 | ||
43842 | 139783 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1551 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003270.3312 | 2113080.6872 | 37.7823015139324 | -122.432351282922 | (37.7823015139324, -122.432351282922) | 15 | 9 | 11 | 29490 | 41 | |||
46997 | 131255 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1699 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004955.8322 | 2118805.77974 | 37.7981166063527 | -122.426928066298 | (37.7981166063527, -122.426928066298) | 13 | 9 | 1 | 57 | 17 | |||
47558 | 116041 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2621 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003988.33907 | 2117916.85991 | 37.7956211081722 | -122.430212424569 | (37.7956211081722, -122.430212424569) | 13 | 9 | 1 | 29490 | 27 | |||
48038 | 102978 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
48803 | 131468 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 749 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6007021.07045 | 2113573.79378 | 37.783867426777 | -122.419410355404 | (37.783867426777, -122.419410355404) | 7 | 9 | 9 | 28858 | 36 | |||
49204 | 101667 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
49708 | 98777 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3700X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003095.78209 | 2121157.07886 | 37.8044673110903 | -122.433532501243 | (37.8044673110903, -122.433532501243) | 13 | 9 | 1 | 57 | 17 | |||
49972 | 131394 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2715 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002101.73237 | 2117508.78781 | 37.7943936109234 | -122.436711181075 | (37.7943936109234, -122.436711181075) | 13 | 9 | 1 | 57 | 27 | |||
50680 | 120969 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 376 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 6007689.7019 | 2112608.237 | 37.7812538778377 | -122.417028695396 | (37.7812538778377, -122.417028695396) | 7 | 9 | 9 | 28852 | 36 | ||||
51536 | 131258 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2052 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6003210.65129 | 2118263.32114 | 37.7965283226679 | -122.432928123558 | (37.7965283226679, -122.432928123558) | 13 | 9 | 1 | 57 | 17 | |||
51558 | 131405 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2775 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6002562.33805 | 2117695.74265 | 37.7949331061182 | -122.435130810564 | (37.7949331061182, -122.435130810564) | 13 | 9 | 1 | 29490 | 27 | |||
52313 | 7731 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3x3 | 6006429.42696 | 2111183.21834 | 37.7772701477293 | -122.4212874096 | (37.7772701477293, -122.4212874096) | 7 | 9 | 11 | 28852 | 10 |
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) );