trees
8,758 rows where qSpecies_id = 16 sorted by Neighborhoods (old) 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) ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9461 | 98346 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1943 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997281 | 2108783 | 37.7701597533774 | -122.452761318704 | (37.7701597533774, -122.452761318704) | 15 | 5 | 11 | 29492 | 9 | ||||
15303 | 246138 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 636 Shrader St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5997581.198 | 2108306.5196 | 37.7688686575946 | -122.451688565499 | (37.7688686575946, -122.451688565499) | 15 | 5 | 11 | 29492 | 9 | |||
19451 | 254404 | Section 806 (d) 5 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 127 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2018 12:00:00 AM | 3 | 3x3 | 5999857 | 2108965 | 37.7708067512445 | -122.443864065657 | (37.7708067512445, -122.443864065657) | 15 | 5 | 11 | 29492 | 9 | ||
22216 | 231368 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1449 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5997818.09683 | 2105707.67989 | 37.7617464678372 | -122.450681756069 | (37.7617464678372, -122.450681756069) | 15 | 5 | 11 | 29492 | 9 | |||
22409 | 231346 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 777 Cole St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 20 | Width 4ft | 5997968.16545 | 2107655.68116 | 37.7671037751345 | -122.450303156776 | (37.7671037751345, -122.450303156776) | 15 | 5 | 11 | 29492 | 9 | |||
23926 | 248545 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 117 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5997472.7852 | 2107770.5122 | 37.7673907090912 | -122.452024879 | (37.7673907090912, -122.452024879) | 15 | 5 | 11 | 29492 | 9 | |||
24089 | 231335 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 146 Alma St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997805.75576 | 2106190.70789 | 37.7630720343675 | -122.45075926683 | (37.7630720343675, -122.45075926683) | 15 | 5 | 11 | 29492 | 9 | |||
27729 | 248475 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 150 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5998297.086 | 2107894.0664 | 37.7677771388916 | -122.449182651332 | (37.7677771388916, -122.449182651332) | 15 | 5 | 11 | 29492 | 9 | |||
28536 | 31687 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 723 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35191 | 5998531.56699721 | 2108118.02123307 | 37.7684054707307 | -122.448387742887 | (37.7684054707307, -122.448387742887) | 15 | 5 | 11 | 29492 | 9 | |||
28600 | 246003 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 79 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5999918.2814 | 2108667.9461 | 37.7699946114022 | -122.443630749638 | (37.7699946114022, -122.443630749638) | 15 | 5 | 11 | 29492 | 9 | |||
30686 | 2172 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1010X Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001284.93622 | 2109041.43324 | 37.7710979644197 | -122.438930293594 | (37.7710979644197, -122.438930293594) | 15 | 5 | 11 | 29492 | 9 | |||
30829 | 231370 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 51 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5998289.8878 | 2106532.23589 | 37.7640374853524 | -122.449109430849 | (37.7640374853524, -122.449109430849) | 15 | 5 | 11 | 29492 | 9 | |||
36473 | 232223 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 664 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002525.91759 | 2108864.22485 | 37.7706819221623 | -122.434625028228 | (37.7706819221623, -122.434625028228) | 15 | 5 | 11 | 29492 | 9 | |||
39150 | 246108 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1899 Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997166.7764 | 2108416.598 | 37.7691471619576 | -122.453129960901 | (37.7691471619576, -122.453129960901) | 15 | 5 | 11 | 29492 | 9 | |||
41207 | 248492 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 38 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5997767.1351 | 2107854.2444 | 37.7676374722768 | -122.45101280697 | (37.7676374722768, -122.45101280697) | 15 | 5 | 11 | 29492 | 9 | |||
42530 | 246934 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 327 Frederick St | 1 | : | Tree | Private 2 | 22 | Width 6ft | 5998433.91472 | 2107557.60959 | 37.7668611389688 | -122.448685143299 | (37.7668611389688, -122.448685143299) | 15 | 5 | 11 | 29492 | 9 | |||
44423 | 231374 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 893 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 5998692.20499 | 2106982.76185 | 37.7652975182978 | -122.447750375375 | (37.7652975182978, -122.447750375375) | 15 | 5 | 11 | 29492 | 9 | |||
44867 | 244921 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 111 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1988 12:00:00 AM | 14 | Width 0ft | Permit Number 25564 | 5999880.7421 | 2108923.4492 | 37.7706940174568 | -122.443778955889 | (37.7706940174568, -122.443778955889) | 15 | 5 | 11 | 29492 | 9 | |
45783 | 99671 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 150X Alma St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
46672 | 248544 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 115 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5997498.5257 | 2107772.632 | 37.7673980038985 | -122.451935999568 | (37.7673980038985, -122.451935999568) | 15 | 5 | 11 | 29492 | 9 | |||
48651 | 232220 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 661 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002541.49113 | 2108820.46983 | 37.7705626657517 | -122.434568030087 | (37.7705626657517, -122.434568030087) | 15 | 5 | 5 | 29492 | 9 | |||
51395 | 248588 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 312 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 5998546.3143 | 2107615.7665 | 37.7670272496993 | -122.448300561447 | (37.7670272496993, -122.448300561447) | 15 | 5 | 11 | 29492 | 9 | |||
51835 | 94497 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600X Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x7 | 5998899.3 | 2109049 | 37.7709827197678 | -122.447182803026 | (37.7709827197678, -122.447182803026) | 15 | 5 | 11 | 29492 | 9 | ||||
52023 | 232640 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 180 Clifford Ter | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5999224.5513 | 2106581.63935 | 37.7642265480279 | -122.445880270264 | (37.7642265480279, -122.445880270264) | 15 | 5 | 5 | 29492 | 9 | |||
54487 | 20105 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1875X Haight St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5997178.90707 | 2108418.46554 | 37.7691529849708 | -122.453088136651 | (37.7691529849708, -122.453088136651) | 15 | 5 | 11 | 29492 | 9 | |||
55203 | 248596 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 358 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5998251.813 | 2107575.6417 | 37.7669002359688 | -122.449316299984 | (37.7669002359688, -122.449316299984) | 15 | 5 | 11 | 29492 | 9 | |||
55403 | 31703 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 424 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35205 | 5997816.4962 | 2107515.2273 | 37.7667094435038 | -122.450817626911 | (37.7667094435038, -122.450817626911) | 15 | 5 | 11 | 29492 | 9 | |
56027 | 231337 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4864 17th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 3ft | 5997898.47143 | 2105660.13743 | 37.7616205285723 | -122.450400346506 | (37.7616205285723, -122.450400346506) | 15 | 5 | 11 | 29492 | 9 | |||
56725 | 231364 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1421 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5997804.83056 | 2105803.64545 | 37.7620092056865 | -122.450734557952 | (37.7620092056865, -122.450734557952) | 15 | 5 | 11 | 29492 | 9 | |||
56881 | 244535 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1870 Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5997139.7338 | 2108471.2939 | 37.7692957929197 | -122.453227448393 | (37.7692957929197, -122.453227448393) | 15 | 5 | 11 | 29492 | 9 | |||
57851 | 67113 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4640 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1992 12:00:00 AM | Permit Number 30531 | 5998824.39993259 | 2105717.10052848 | 37.7618298844676 | -122.447202049097 | (37.7618298844676, -122.447202049097) | 15 | 5 | 11 | 29492 | 9 | ||
58722 | 231347 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 781 Cole St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 4ft | 5997971.47972 | 2107628.15959 | 37.7670283975778 | -122.450289709197 | (37.7670283975778, -122.450289709197) | 15 | 5 | 11 | 29492 | 9 | |||
59309 | 56945 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 136 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1974 12:00:00 AM | 16 | 3x3 | Permit Number 14196 | 5999410.54979038 | 2107426.88584644 | 37.7665580018268 | -122.445297733802 | (37.7665580018268, -122.445297733802) | 15 | 5 | 5 | 29492 | 9 | |
59550 | 232643 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 136 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5999405.98946 | 2107393.2497 | 37.7664653850985 | -122.445311088443 | (37.7664653850985, -122.445311088443) | 15 | 5 | 5 | 29492 | 9 | |||
59814 | 245212 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 161 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6001288.9017 | 2109308.3346 | 37.7718310345544 | -122.438935707277 | (37.7718310345544, -122.438935707277) | 15 | 5 | 11 | 29492 | 9 | |||
60982 | 231345 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 773 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5997966.8829 | 2107678.93686 | 37.7671675559698 | -122.450309269459 | (37.7671675559698, -122.450309269459) | 15 | 5 | 11 | 29492 | 9 | |||
61517 | 246925 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 379 Frederick St | 1 | : | Tree | Private 2 | 20 | Width 5ft | 5998143.47338 | 2107513.56427 | 37.7667235894447 | -122.449686553707 | (37.7667235894447, -122.449686553707) | 15 | 5 | 11 | 29492 | 9 | |||
64846 | 231378 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1126 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5997727.0172 | 2106629.49901 | 37.7642723361366 | -122.451063239472 | (37.7642723361366, -122.451063239472) | 15 | 5 | 11 | 29492 | 9 | |||
68434 | 20103 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1875X Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5997178.90707 | 2108418.46554 | 37.7691529849708 | -122.453088136651 | (37.7691529849708, -122.453088136651) | 15 | 5 | 11 | 29492 | 9 | |||
69380 | 244534 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1860 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997154.6875 | 2108465.3124 | 37.7692802263211 | -122.453175292694 | (37.7692802263211, -122.453175292694) | 15 | 5 | 11 | 29492 | 9 | |||
70348 | 64704 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1085 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1991 12:00:00 AM | Permit Number 29615 | 6001383.56240143 | 2109351.50680383 | 37.7719549599889 | -122.438611364027 | (37.7719549599889, -122.438611364027) | 15 | 5 | 11 | 29492 | 9 | ||
72938 | 14609 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600X Masonic Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 5999910.64606 | 2106981.68458 | 37.7653641243935 | -122.443536010899 | (37.7653641243935, -122.443536010899) | 15 | 5 | 5 | 29492 | 9 | |||
76953 | 14607 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600X Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 5999910.64606 | 2106981.68458 | 37.7653641243935 | -122.443536010899 | (37.7653641243935, -122.443536010899) | 15 | 5 | 5 | 29492 | 9 | |||
79314 | 59923 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1148 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 19393 | 5997378.92554481 | 2106299.03543862 | 37.7633450321458 | -122.452243337077 | (37.7633450321458, -122.452243337077) | 15 | 5 | 11 | 29492 | 9 | ||
80185 | 231333 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 121 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5997940.66819 | 2106795.49993 | 37.7647403621898 | -122.450336251826 | (37.7647403621898, -122.450336251826) | 15 | 5 | 11 | 29492 | 9 | |||
83719 | 231348 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 793 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5997981.16167 | 2107583.96324 | 37.7669075997244 | -122.450253034865 | (37.7669075997244, -122.450253034865) | 15 | 5 | 11 | 29492 | 9 | |||
86835 | 246000 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 87 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999914.9503 | 2108691.264 | 37.7700584464999 | -122.443643947183 | (37.7700584464999, -122.443643947183) | 15 | 5 | 11 | 29492 | 9 | |||
87008 | 244187 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1685 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998490.1608 | 2108949.065 | 37.7706849379722 | -122.448590822718 | (37.7706849379722, -122.448590822718) | 15 | 5 | 11 | 29492 | 9 | |||
88496 | 231359 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1450 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997857.64895 | 2105687.27515 | 37.7616927054669 | -122.450543490698 | (37.7616927054669, -122.450543490698) | 15 | 5 | 11 | 29492 | 9 | |||
90184 | 14608 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600X Masonic Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 5999910.64606 | 2106981.68458 | 37.7653641243935 | -122.443536010899 | (37.7653641243935, -122.443536010899) | 15 | 5 | 5 | 29492 | 9 | |||
90748 | 231375 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 46 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998416.07407 | 2106902.86654 | 37.7650623599704 | -122.448699688063 | (37.7650623599704, -122.448699688063) | 15 | 5 | 11 | 29492 | 9 | |||
92719 | 231336 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4864 17th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 3ft | 5997916.37939 | 2105662.10504 | 37.7616269560303 | -122.45033855229 | (37.7616269560303, -122.45033855229) | 15 | 5 | 11 | 29492 | 9 | |||
92975 | 248401 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 721 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | 10 | Width 0ft | Permit Number 35191 | 5998539.5007 | 2108099.8388 | 37.7683559999766 | -122.448358991521 | (37.7683559999766, -122.448358991521) | 15 | 5 | 11 | 29492 | 9 | |
94523 | 99689 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 150X Alma St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
95191 | 246086 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 38 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998225.7697 | 2108390.5547 | 37.7691362900816 | -122.449465102579 | (37.7691362900816, -122.449465102579) | 15 | 5 | 11 | 29492 | 9 | |||
96898 | 245902 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 132 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001329.5899 | 2109317.4651 | 37.7718584195301 | -122.438795618701 | (37.7718584195301, -122.438795618701) | 15 | 5 | 11 | 29492 | 9 | |||
97378 | 248516 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 167 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998268.1658 | 2107791.256 | 37.7674931934777 | -122.449275274398 | (37.7674931934777, -122.449275274398) | 15 | 5 | 11 | 29492 | 9 | |||
98451 | 247363 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 24 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5997825.8839 | 2107862.4208 | 37.7676632857888 | -122.450810192904 | (37.7676632857888, -122.450810192904) | 15 | 5 | 11 | 29492 | 9 | |||
98883 | 245054 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1060 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001477.333 | 2109414.6864 | 37.7721337692093 | -122.438291532216 | (37.7721337692093, -122.438291532216) | 15 | 5 | 11 | 29492 | 9 | |||
101148 | 231377 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 76 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998278.28739 | 2106886.39953 | 37.7650092657986 | -122.44917506967 | (37.7650092657986, -122.44917506967) | 15 | 5 | 11 | 29492 | 9 | |||
106378 | 101972 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 150 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5998294 | 2107899 | 37.7677905087949 | -122.449193680863 | (37.7677905087949, -122.449193680863) | 15 | 5 | 11 | 29492 | 9 | |||
106597 | 58637 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1126 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/1979 12:00:00 AM | Permit Number 17857 | 5997724.58706979 | 2106697.57831066 | 37.7644591255027 | -122.451076554304 | (37.7644591255027, -122.451076554304) | 15 | 5 | 11 | 29492 | 9 | |||
106793 | 231363 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1409 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5997795.4578 | 2105849.44977 | 37.762134436272 | -122.450770277225 | (37.762134436272, -122.450770277225) | 15 | 5 | 11 | 29492 | 9 | |||
106921 | 231360 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1444 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5997853.47563 | 2105715.49589 | 37.76176995364 | -122.450559959073 | (37.76176995364, -122.450559959073) | 15 | 5 | 11 | 29492 | 9 | |||
107308 | 246107 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1899 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5997126.5002 | 2108412.0556 | 37.7691323812935 | -122.453268945279 | (37.7691323812935, -122.453268945279) | 15 | 5 | 11 | 29492 | 9 | |||
108096 | 246106 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1899 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5997112.57 | 2108409.6329 | 37.7691249307448 | -122.453316953855 | (37.7691249307448, -122.453316953855) | 15 | 5 | 11 | 29492 | 9 | |||
108660 | 105368 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 180 CLIFFORD TER | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999283.1 | 2106587.2 | 37.7642451591147 | -122.445678167683 | (37.7642451591147, -122.445678167683) | 15 | 5 | 5 | 29492 | 9 | ||||||
109727 | 231369 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 482 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5998576.09689 | 2106398.57527 | 37.7636868522961 | -122.448109897359 | (37.7636868522961, -122.448109897359) | 15 | 5 | 11 | 29492 | 9 | |||
110923 | 20099 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1850X Haight St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/1990 12:00:00 AM | 60 | 3X3 | 5997137.46186 | 2108472.54572 | 37.7692990998786 | -122.453235397263 | (37.7692990998786, -122.453235397263) | 15 | 5 | 11 | 29492 | 9 | ||
111249 | 244188 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1685 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998510.2415 | 2108951.6285 | 37.7706931248645 | -122.448521548218 | (37.7706931248645, -122.448521548218) | 15 | 5 | 11 | 29492 | 9 | |||
114756 | 231366 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1437 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5997810.62198 | 2105758.3632 | 37.7618852035598 | -122.450711262824 | (37.7618852035598, -122.450711262824) | 15 | 5 | 11 | 29492 | 9 | |||
117249 | 110651 | Section 143 10 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 127 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5999845 | 2108967 | 37.770811558248 | -122.44390571749 | (37.770811558248, -122.44390571749) | 15 | 5 | 11 | 29492 | 9 | |||
117775 | 46175 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1683 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2002 12:00:00 AM | Permit Number 44503 | 5998530.31585912 | 2108952.87807523 | 37.7706977036512 | -122.448452200999 | (37.7706977036512, -122.448452200999) | 15 | 5 | 11 | 29492 | 9 | ||
118389 | 231334 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 146 Alma St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997829.6569 | 2106193.26288 | 37.7630804178625 | -122.450676785511 | (37.7630804178625, -122.450676785511) | 15 | 5 | 11 | 29492 | 9 | |||
118465 | 231349 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 799 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5997985.40966 | 2107567.33298 | 37.7668621803618 | -122.450237142952 | (37.7668621803618, -122.450237142952) | 15 | 5 | 11 | 29492 | 9 | |||
119866 | 244119 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1922 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 5997352.574 | 2108839.349 | 37.7703185742655 | -122.452517813286 | (37.7703185742655, -122.452517813286) | 15 | 5 | 11 | 29492 | 9 | |||
123538 | 10515 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1801 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/23/2017 12:00:00 AM | 3 | 3X3 | 5997497.7686 | 2108463.8393 | 37.7692958388006 | -122.451988492124 | (37.7692958388006, -122.451988492124) | 15 | 5 | 11 | 29492 | 9 | ||
125126 | 248591 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 193 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5998290.5751 | 2107632.2707 | 37.7670579419676 | -122.449186308876 | (37.7670579419676, -122.449186308876) | 15 | 5 | 11 | 29492 | 9 | |||
125578 | 232641 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 180 Clifford Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5999241.6701 | 2106577.99035 | 37.764217506249 | -122.445820798992 | (37.764217506249, -122.445820798992) | 15 | 5 | 5 | 29492 | 9 | |||
125726 | 113380 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 63 Potomac St | 1 | Front Yard : Yard | Tree | Private 2 | 4x4 | Permit Number 776311 | 6003081 | 2108682.5 | 37.7702144463181 | -122.432692008068 | (37.7702144463181, -122.432692008068) | 15 | 5 | 5 | 29492 | 9 | |||
126714 | 244080 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5998828.542 | 2109045.196 | 37.7709682317452 | -122.447427282162 | (37.7709682317452, -122.447427282162) | 15 | 5 | 11 | 29492 | 9 | |||
127570 | 231351 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4708 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998590.1263 | 2105697.78452 | 37.7617634587405 | -122.448010914378 | (37.7617634587405, -122.448010914378) | 15 | 5 | 11 | 29492 | 9 | |||
129601 | 248587 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 308 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5998565.9982 | 2107618.1891 | 37.7670350268661 | -122.448232652643 | (37.7670350268661, -122.448232652643) | 15 | 5 | 11 | 29492 | 9 | |||
130159 | 245898 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1085 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001347.2061 | 2109348.3765 | 37.7719442967153 | -122.438736898562 | (37.7719442967153, -122.438736898562) | 15 | 5 | 11 | 29492 | 9 | |||
130252 | 247667 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 140 Divisadero St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6001942.4727 | 2108474.82716 | 37.7695795934622 | -122.436615292671 | (37.7695795934622, -122.436615292671) | 15 | 5 | 5 | 29492 | 9 | |||
131040 | 232221 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 48 Potomac St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003139.11255 | 2108588.6984 | 37.7699601856506 | -122.432484296435 | (37.7699601856506, -122.432484296435) | 15 | 5 | 5 | 29492 | 9 | |||
131854 | 32005 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1937 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1995 12:00:00 AM | 7 | Permit Number 35400 | 5997296.0313 | 2108778.2664 | 37.7701476174336 | -122.452708984159 | (37.7701476174336, -122.452708984159) | 15 | 5 | 11 | 29492 | 9 | ||
133503 | 246008 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 77 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5999921.3097 | 2108643.1142 | 37.7699266019699 | -122.443618490714 | (37.7699266019699, -122.443618490714) | 15 | 5 | 11 | 29492 | 9 | |||
133781 | 14610 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600X Masonic Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 5999910.64606 | 2106981.68458 | 37.7653641243935 | -122.443536010899 | (37.7653641243935, -122.443536010899) | 15 | 5 | 5 | 29492 | 9 | |||
134233 | 244036 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1943 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997260.95 | 2108772.901 | 37.7701308752093 | -122.452829942072 | (37.7701308752093, -122.452829942072) | 15 | 5 | 11 | 29492 | 9 | |||
134409 | 20102 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1875X Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5997178.90707 | 2108418.46554 | 37.7691529849708 | -122.453088136651 | (37.7691529849708, -122.453088136651) | 15 | 5 | 11 | 29492 | 9 | |||
134886 | 231367 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1437 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5997812.2588 | 2105750.7277 | 37.7618643320959 | -122.450705051202 | (37.7618643320959, -122.450705051202) | 15 | 5 | 11 | 29492 | 9 | |||
135386 | 248449 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 24 Beulah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5997779.2482 | 2107856.667 | 37.7676448175878 | -122.450971084206 | (37.7676448175878, -122.450971084206) | 15 | 5 | 11 | 29492 | 9 | |||
135829 | 231372 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4640 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998726.6752 | 2105707.10014 | 37.7617968415832 | -122.447539318886 | (37.7617968415832, -122.447539318886) | 15 | 5 | 11 | 29492 | 9 | |||
139005 | 10514 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1801 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5997476.97726 | 2108439.50555 | 37.7692278336416 | -122.452058652072 | (37.7692278336416, -122.452058652072) | 15 | 5 | 11 | 29492 | 9 | |||
139641 | 231376 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 76 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998297.43759 | 2106888.1155 | 37.7650150727198 | -122.44910895782 | (37.7650150727198, -122.44910895782) | 15 | 5 | 11 | 29492 | 9 | |||
140042 | 248590 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 191 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5998289.061 | 2107644.3839 | 37.7670911151398 | -122.44919241866 | (37.7670911151398, -122.44919241866) | 15 | 5 | 11 | 29492 | 9 | |||
141226 | 247364 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 24 Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997814.3764 | 2107860.301 | 37.7676568066142 | -122.450849842845 | (37.7676568066142, -122.450849842845) | 15 | 5 | 11 | 29492 | 9 | |||
141227 | 232222 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 84 Potomac St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003096.71082 | 2108877.59611 | 37.7707510233664 | -122.432651602691 | (37.7707510233664, -122.432651602691) | 15 | 5 | 5 | 29492 | 9 | |||
141639 | 39770 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 45 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/1999 12:00:00 AM | Permit Number 41137 | 5998362.29887473 | 2106534.9134953 | 37.7640489786195 | -122.448859176232 | (37.7640489786195, -122.448859176232) | 15 | 5 | 11 | 29492 | 9 |
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) );