Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
132990 | 132990 | 234397 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3932 22nd St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 25 | Width 4ft | 6002267.50929 | 2102984.90864 | 37.7545240763369 | -122.435098296447 | (37.7545240763369, -122.435098296447) | |||
177164 | 177164 | 234402 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 667 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6002514.48058 | 2108813.7305400004 | 37.7705426279609 | -122.434660977745 | (37.7705426279609, -122.434660977745) | |||
18227 | 18227 | 25534 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002560.5766 | 2106158.8258 | 37.763255525853296 | -122.43431169398701 | (37.7632555258533, -122.434311693987) | ||
20343 | 20343 | 25533 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002574.775 | 2106170.8945 | 37.7632894694666 | -122.43426344933201 | (37.7632894694666, -122.434263449332) | ||
18199 | 18199 | 25532 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002592.5231 | 2106186.5128 | 37.7633333608706 | -122.43420318116999 | (37.7633333608706, -122.43420318117) | ||
19415 | 19415 | 25531 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002640.0878 | 2106231.2379 | 37.763458864653295 | -122.434041867896 | (37.7634588646533, -122.434041867896) | ||
21974 | 21974 | 25530 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002661.3855 | 2106250.4058 | 37.7635127037236 | -122.433969576289 | (37.7635127037236, -122.433969576289) | ||
20414 | 20414 | 25529 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002679.8435 | 2106267.4439 | 37.7635605336875 | -122.43390695394699 | (37.7635605336875, -122.433906953947) | ||
18754 | 18754 | 25528 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002714.6296 | 2106302.2301 | 37.7636580221412 | -122.433789126424 | (37.7636580221412, -122.433789126424) | ||
17397 | 17397 | 25527 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002730.2479 | 2106324.2376 | 37.7637193356407 | -122.433736680672 | (37.7637193356407, -122.433736680672) | ||
17411 | 17411 | 25526 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002746.7355 | 2106338.4868 | 37.7637593960329 | -122.43368067367201 | (37.7637593960329, -122.433680673672) | ||
164059 | 164059 | 178087 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 201 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6003003.324659999 | 2086943.97699 | 37.7105210777575 | -122.431408625424 | (37.7105210777575, -122.431408625424) | |||
176009 | 176009 | 234379 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 246 Bemis St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 6003018.34772 | 2096316.7253 | 37.736257406663704 | -122.432025563025 | (37.7362574066637, -122.432025563025) | ||||
130062 | 130062 | 178088 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 201 Chicago Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 3ft | 6003023.7628 | 2086943.7814599997 | 37.7105216991954 | -122.431337972882 | (37.7105216991954, -122.431337972882) | |||
182456 | 182456 | 234394 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350 Noe St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 6003187.2989 | 2100371.4904099996 | 37.7474004312881 | -122.431730842629 | (37.7474004312881, -122.431730842629) | ||||
19013 | 19013 | 25540 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003208.8276 | 2106774.142 | 37.7649818088085 | -122.43211355317601 | (37.7649818088085, -122.432113553176) | ||
22015 | 22015 | 25539 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003230.8711 | 2106796.1855 | 37.7650435846647 | -122.432038884515 | (37.7650435846647, -122.432038884515) | ||
17149 | 17149 | 25538 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003277.964 | 2106841.2745 | 37.7651700578839 | -122.431879221699 | (37.7651700578839, -122.431879221699) | ||
21747 | 21747 | 25537 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003301.0095 | 2106860.3121 | 37.7652236369165 | -122.43180087233601 | (37.7652236369165, -122.431800872336) | ||
21723 | 21723 | 25536 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003342.0906 | 2106904.3991 | 37.7653470177984 | -122.43166193058599 | (37.7653470177984, -122.431661930586) | ||
21853 | 21853 | 25535 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003362.1302 | 2106920.4307 | 37.765392172561796 | -122.431593762963 | (37.7653921725618, -122.431593762963) | ||
89820 | 89820 | 25524 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2194X Market St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003574.351798001 | 2107172.9273566003 | 37.766097493813604 | -122.430877759148 | (37.7660974938136, -122.430877759148) | ||
94509 | 94509 | 25522 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2194X Market St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003574.351798001 | 2107172.9273566003 | 37.766097493813604 | -122.430877759148 | (37.7660974938136, -122.430877759148) | ||
97191 | 97191 | 25521 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2194X Market St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003574.351798001 | 2107172.9273566003 | 37.766097493813604 | -122.430877759148 | (37.7660974938136, -122.430877759148) | ||
121520 | 121520 | 25525 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2194X Market St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003574.351798001 | 2107172.9273566003 | 37.766097493813604 | -122.430877759148 | (37.7660974938136, -122.430877759148) | ||
127344 | 127344 | 25523 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2194X Market St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003574.351798001 | 2107172.9273566003 | 37.766097493813604 | -122.430877759148 | (37.7660974938136, -122.430877759148) | ||
142041 | 142041 | 25520 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2194X Market St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003574.351798001 | 2107172.9273566003 | 37.766097493813604 | -122.430877759148 | (37.7660974938136, -122.430877759148) | ||
21387 | 21387 | 25517 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2190X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003660.4353 | 2107205.9591 | 37.7661930680529 | -122.43058237071199 | (37.7661930680529, -122.430582370712) | ||
126077 | 126077 | 51202 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 567 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47573 | 6003673.55383836 | 2104968.22861825 | 37.760049541377796 | -122.43037732338999 | (37.7600495413778, -122.43037732339) | ||||
17621 | 17621 | 25516 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2190X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003679.0354 | 2107225.3342 | 37.7662473210814 | -122.430519419203 | (37.7662473210814, -122.430519419203) | ||
135557 | 135557 | 246409 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2190x Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 0ft | 6003700.7355 | 2107248.5843 | 37.7663123894934 | -122.43044602180001 | (37.7663123894934, -122.4304460218) | |||
138553 | 138553 | 116529 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 745X SANCHEZ ST | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | ||||
24559 | 24559 | 246349 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2190x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 31 | Width 0ft | 6003723.2107 | 2107266.4094 | 37.766362606026796 | -122.430369556243 | (37.7663626060268, -122.430369556243) | |||
171635 | 171635 | 234401 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3899 19th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 3ft | 6003740.055819999 | 2104771.47672 | 37.75951307439 | -122.430133288745 | (37.75951307439, -122.430133288745) | |||
136243 | 136243 | 246359 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2150x Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6003779.011 | 2107326.8598 | 37.766531748826 | -122.430180866432 | (37.766531748826, -122.430180866432) | |||
54798 | 54798 | 246348 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2150x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6003809.2361 | 2107348.5599 | 37.766593043924 | -122.430077871393 | (37.766593043924, -122.430077871393) | |||
21187 | 21187 | 25519 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100X Market St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003894.4866 | 2107428.3854 | 37.7668170533219 | -122.42978869913401 | (37.7668170533219, -122.429788699134) | ||
20599 | 20599 | 25518 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100X Market St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003909.9867 | 2107446.2105 | 37.7668668744555 | -122.429736358347 | (37.7668668744555, -122.429736358347) | ||
178250 | 178250 | 246357 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100x Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6003963.462 | 2107490.3857 | 37.7669911968193 | -122.429554546796 | (37.7669911968193, -122.429554546796) | |||
181978 | 181978 | 246356 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100x Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6003986.7122 | 2107511.3108 | 37.7670499684983 | -122.429475620431 | (37.7670499684983, -122.429475620431) | |||
163198 | 163198 | 234393 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1557 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003994.29589 | 2099192.81462 | 37.7442097715744 | -122.42885628561001 | (37.7442097715744, -122.42885628561) | |||
22145 | 22145 | 25515 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6004020.8124 | 2107556.2611 | 37.767175321793 | -122.429360878869 | (37.767175321793, -122.429360878869) | ||
19946 | 19946 | 25514 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6004037.0875 | 2107573.3112 | 37.7672230586461 | -122.429305801661 | (37.7672230586461, -122.429305801661) | ||
163388 | 163388 | 233927 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 389 Webster St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6004115.83529 | 2109995.53754 | 37.7738783609231 | -122.429206159632 | (37.7738783609231, -122.429206159632) | |||
76295 | 76295 | 246340 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020x Market St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6004296.5773 | 2107812.2068 | 37.767893695460295 | -122.428425293549 | (37.7678936954603, -122.428425293549) | |||
132737 | 132737 | 246343 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020x Market St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6004317.012999999 | 2107828.8108 | 37.767940442417604 | -122.428355792358 | (37.7679404424176, -122.428355792358) | |||
25198 | 25198 | 246342 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020x Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | Width 0ft | 6004356.6072 | 2107872.2367 | 37.7680619198287 | -122.42822193571301 | (37.7680619198287, -122.428221935713) | |||
18461 | 18461 | 24339 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004378.3201 | 2107887.5635 | 37.7681052320451 | -122.42814792550399 | (37.7681052320451, -122.428147925504) | ||
17405 | 17405 | 24337 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004420.4688 | 2107930.9893 | 37.7682268534635 | -122.428005232451 | (37.7682268534635, -122.428005232451) | ||
19585 | 19585 | 24338 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004443.4589 | 2107950.1478 | 37.76828075872071 | -122.42792707731 | (37.7682807587207, -122.42792707731) | ||
98131 | 98131 | 100536 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2050X Market St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004529.3 | 2108103.5 | 37.7687066827543 | -122.427641088373 | (37.7687066827543, -122.427641088373) | |||
108626 | 108626 | 100535 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2050X Market St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004529.3 | 2108103.5 | 37.7687066827543 | -122.427641088373 | (37.7687066827543, -122.427641088373) | |||
20710 | 20710 | 24340 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2000X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004586.5088 | 2108095.7522 | 37.7686886449818 | -122.42744265544201 | (37.7686886449818, -122.427442655442) | ||
182459 | 182459 | 246404 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2000x Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 0ft | 6004606.9445 | 2108108.5245 | 37.7687248704296 | -122.427372879895 | (37.7687248704296, -122.427372879895) | |||
64559 | 64559 | 246403 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2000x Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 0ft | 6004628.6575 | 2108127.683 | 37.7687787030374 | -122.427299141169 | (37.7687787030374, -122.427299141169) | |||
36176 | 36176 | 246402 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2000x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | Width 0ft | 6004659.311000001 | 2108158.3365 | 37.7688646036969 | -122.42719529666901 | (37.7688646036969, -122.427195296669) | |||
109140 | 109140 | 25155 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 60X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004737.5115877995 | 2107959.1242988 | 37.768322037027 | -122.426910616409 | (37.768322037027, -122.426910616409) | |||
170283 | 170283 | 234385 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 384 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004737.93375 | 2109866.7423400003 | 37.773559918201606 | -122.427045042888 | (37.7735599182016, -122.427045042888) | |||
17821 | 17821 | 25151 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004775.21348 | 2108066.2440299997 | 37.768618293721104 | -122.42678783858999 | (37.7686182937211, -122.42678783859) | |||
20149 | 20149 | 25149 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20x10 | 6004775.29887 | 2108114.09165 | 37.768749676587205 | -122.42679095116002 | (37.7687496765872, -122.42679095116) | |||
19492 | 19492 | 25148 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6004781.85822 | 2108123.31219 | 37.7687753648286 | -122.426768919571 | (37.7687753648286, -122.426768919571) | |||
17442 | 17442 | 25157 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004782.44605 | 2108032.94108 | 37.7685272607631 | -122.42676044975201 | (37.7685272607631, -122.426760449752) | |||
19325 | 19325 | 25154 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004786.45589 | 2107937.0696900003 | 37.7682642477152 | -122.42673975183901 | (37.7682642477152, -122.426739751839) | |||
21462 | 21462 | 25153 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004788.48534 | 2107965.7019599997 | 37.768342979778204 | -122.426734771418 | (37.7683429797782, -122.426734771418) | |||
22064 | 22064 | 25150 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 6004790.11345 | 2107911.6189 | 37.7681945727608 | -122.42672528803699 | (37.7681945727608, -122.426725288037) | |||
19960 | 19960 | 25156 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004792.45266 | 2107880.8578 | 37.768110242434204 | -122.426715006093 | (37.7681102424342, -122.426715006093) | |||
18340 | 18340 | 25152 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004796.34623 | 2107853.39536 | 37.768035057311 | -122.42669958273999 | (37.768035057311, -122.42669958274) | |||
17252 | 17252 | 24963 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004800.736959999 | 2107633.50365 | 37.7674315357679 | -122.42666873508999 | (37.7674315357679, -122.42666873509) | |||
22009 | 22009 | 24961 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2005 12:00:00 AM | 90 | 20 | 6004800.95891 | 2107734.51921 | 37.76770891277079 | -122.42667516163999 | (37.7677089127708, -122.42667516164) | ||
19826 | 19826 | 24965 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004804.04595 | 2107595.6918 | 37.767327900586 | -122.42665459683799 | (37.767327900586, -122.426654596838) | |||
82993 | 82993 | 24964 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 198 Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004804.6555297 | 2107199.7616194002 | 37.766240805753604 | -122.426624291348 | (37.7662408057536, -122.426624291348) | |||
101220 | 101220 | 26535 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 198 Dolores St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/23/1997 12:00:00 AM | 70 | 20 | 6004804.6555297 | 2107199.7616194002 | 37.766240805753604 | -122.426624291348 | (37.7662408057536, -122.426624291348) | ||
117814 | 117814 | 24973 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 198 Dolores St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004804.6555297 | 2107199.7616194002 | 37.766240805753604 | -122.426624291348 | (37.7662408057536, -122.426624291348) | |||
142252 | 142252 | 24972 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 198 Dolores St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004804.6555297 | 2107199.7616194002 | 37.766240805753604 | -122.426624291348 | (37.7662408057536, -122.426624291348) | |||
19334 | 19334 | 24962 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2005 12:00:00 AM | 30 | 20 | 6004805.8872 | 2107667.07109 | 37.76752399506629 | -122.42665331171999 | (37.7675239950663, -122.42665331172) | ||
19333 | 19333 | 24968 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004810.58196 | 2107534.1310400004 | 37.767159239034704 | -122.426627605497 | (37.7671592390347, -122.426627605497) | |||
20452 | 20452 | 24966 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004812.73188 | 2107584.41194 | 37.76729741985871 | -122.426623750096 | (37.7672974198587, -122.426623750096) | |||
182641 | 182641 | 233932 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004814.58298 | 2107439.6885599997 | 37.7669001488458 | -122.426607040704 | (37.7669001488458, -122.426607040704) | ||||
107086 | 107086 | 100539 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2010X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004815.4 | 2108376.1 | 37.7694713555808 | -122.426670904591 | (37.7694713555808, -122.426670904591) | |||
110301 | 110301 | 100540 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2010X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004815.4 | 2108376.1 | 37.7694713555808 | -122.426670904591 | (37.7694713555808, -122.426670904591) | |||
126653 | 126653 | 100537 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2010X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004815.4 | 2108376.1 | 37.7694713555808 | -122.426670904591 | (37.7694713555808, -122.426670904591) | |||
138567 | 138567 | 100538 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2010X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004815.4 | 2108376.1 | 37.7694713555808 | -122.426670904591 | (37.7694713555808, -122.426670904591) | |||
73360 | 73360 | 233933 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 6004817.19467 | 2107404.1110799997 | 37.76680260927 | -122.426595473608 | (37.76680260927, -122.426595473608) | ||||
27176 | 27176 | 24980 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
86637 | 86637 | 24981 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
97883 | 97883 | 24986 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
100281 | 100281 | 24985 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
113614 | 113614 | 24982 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
72308 | 72308 | 233934 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150x Dolores St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6004824.15396 | 2107326.99928 | 37.7665912721916 | -122.42656591108101 | (37.7665912721916, -122.426565911081) | ||||
18853 | 18853 | 24967 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150 Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004824.658890001 | 2107297.38564 | 37.7665099887808 | -122.42656205570499 | (37.7665099887808, -122.426562055705) | |||
24494 | 24494 | 233935 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150x Dolores St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6004826.52958 | 2107279.95522 | 37.766462234780604 | -122.426554344032 | (37.7664622347806, -122.426554344032) | ||||
18703 | 18703 | 24975 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 200 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004832.79825 | 2107115.15692 | 37.76601009251021 | -122.426520926121 | (37.7660100925102, -122.426520926121) | |||
20630 | 20630 | 24974 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 200 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004833.67989 | 2107139.93189 | 37.7660781684855 | -122.426519640982 | (37.7660781684855, -122.426519640982) | |||
41120 | 41120 | 233936 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 230x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6004841.8872 | 2106976.70647 | 37.7656304545194 | -122.42647963012699 | (37.7656304545194, -122.426479630127) | ||||
35273 | 35273 | 233937 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 230x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | 6004843.94175 | 2106947.59382 | 37.7655506342911 | -122.42647045077801 | (37.7655506342911, -122.426470450778) | ||||
170250 | 170250 | 233938 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 230x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6004845.02149 | 2106914.0966 | 37.7654587199743 | -122.426464330874 | (37.7654587199743, -122.426464330874) | ||||
136108 | 136108 | 234331 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 3ft | 6004849.00155 | 2105814.83535 | 37.762440635635 | -122.426372290646 | (37.762440635635, -122.426372290646) | |||
29021 | 29021 | 234332 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6004849.34041 | 2105800.52772 | 37.7624013694379 | -122.42637009990601 | (37.7624013694379, -122.426370099906) | |||
71756 | 71756 | 233939 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 270x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | 6004850.2917 | 2106826.33652 | 37.765218049699605 | -122.426439853137 | (37.7652180496996, -122.426439853137) | ||||
49252 | 49252 | 233940 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 270x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6004851.53435 | 2106800.76384 | 37.7651479034782 | -122.426433734123 | (37.7651479034782, -122.426433734123) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");