Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23791 | 23791 | 245271 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 217 Ogden Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 6008459.65813 | 2096082.8630400002 | 37.7359222563084 | -122.41319610842501 | (37.7359222563084, -122.413196108425) | |||
30616 | 30616 | 246455 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 405 Duncan St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6003830.51573 | 2099804.43405 | 37.7458798656648 | -122.42946621029199 | (37.7458798656648, -122.429466210292) | |||
31871 | 31871 | 136566 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1218 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6007796.91649 | 2118215.26217 | 37.796655426567995 | -122.41705519283998 | (37.796655426568, -122.41705519284) | |||
34845 | 34845 | 136565 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1218 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6007807.752640001 | 2118217.01551 | 37.7966608503694 | -122.41701782152 | (37.7966608503694, -122.41701782152) | |||
36190 | 36190 | 250885 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 187 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986783.84755 | 2114537.6014900003 | 37.7853531643506 | -122.48949359617399 | (37.7853531643506, -122.489493596174) | |||
39627 | 39627 | 215162 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 50 Sola Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5994831.77603 | 2100788.44228 | 37.7480681050619 | -122.46065367545201 | (37.7480681050619, -122.460653675452) | |||
40500 | 40500 | 136560 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1338 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007223.0393900005 | 2115956.5556799998 | 37.790421280275204 | -122.418880665529 | (37.7904212802752, -122.418880665529) | |||
40513 | 40513 | 215151 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 748 Lakeview Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 5994563.14295 | 2089947.14984 | 37.718285116550604 | -122.460797016589 | (37.7182851165506, -122.460797016589) | |||
40975 | 40975 | 136575 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 145 Jefferson St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6008547.84348 | 2122425.8799900003 | 37.8082589427652 | -122.414754947386 | (37.8082589427652, -122.414754947386) | |||
45567 | 45567 | 136554 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 900 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006026.1660400005 | 2113167.48716 | 37.7826957225725 | -122.42282347503401 | (37.7826957225725, -122.422823475034) | |||
47884 | 47884 | 250887 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 187 29th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986787.08034 | 2114502.94552 | 37.785258197747396 | -122.48947986261801 | (37.7852581977474, -122.489479862618) | |||
48390 | 48390 | 136577 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 145 Jefferson St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6008571.571 | 2122426.8500200002 | 37.8082629393464 | -122.414672900433 | (37.8082629393464, -122.414672900433) | |||
53727 | 53727 | 246457 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 405 Duncan St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 6003845.17231 | 2099806.01088 | 37.7458850250928 | -122.429415642312 | (37.7458850250928, -122.429415642312) | |||
54062 | 54062 | 136578 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 145 Jefferson St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6008572.42572 | 2122428.93464 | 37.808268711206004 | -122.41467009005899 | (37.808268711206, -122.414670090059) | |||
55757 | 55757 | 246454 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 405 Duncan St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 6003816.34015 | 2099803.317 | 37.7458759958985 | -122.429515147817 | (37.7458759958985, -122.429515147817) | |||
57031 | 57031 | 136576 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 145 Jefferson St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6008548.79083 | 2122424.56718 | 37.8082553913493 | -122.41475157584999 | (37.8082553913493, -122.41475157585) | |||
58829 | 58829 | 247643 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 632 Banks St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6008488.56377 | 2095899.2199799998 | 37.7354196351 | -122.41308318864401 | (37.7354196351, -122.413083188644) | |||
59982 | 59982 | 245294 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 525 Day St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 6002498.65421 | 2098563.13018 | 37.7423960377374 | -122.433982882617 | (37.7423960377374, -122.433982882617) | |||
60287 | 60287 | 136528 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3271 Baker St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 5999283.78896 | 2120122.72812 | 37.8014102447475 | -122.44664972480601 | (37.8014102447475, -122.446649724806) | |||
62945 | 62945 | 136537 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2985 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5999914.5201 | 2116710.99494 | 37.792078539253396 | -122.44422181518999 | (37.7920785392534, -122.44422181519) | |||
64229 | 64229 | 136553 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 900 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006040.70209 | 2113171.61603 | 37.7827078795925 | -122.422773479935 | (37.7827078795925, -122.422773479935) | |||
68653 | 68653 | 248023 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 447 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6009976.04009 | 2098394.24313 | 37.7423538217629 | -122.40811630944599 | (37.7423538217629, -122.408116309446) | |||
69059 | 69059 | 197773 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1601 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6012487.363480001 | 2106076.40737 | 37.76358766964871 | -122.399972213573 | (37.7635876696487, -122.399972213573) | |||
69079 | 69079 | 215161 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 50 Sola Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994838.83006 | 2100785.5389400003 | 37.7480605390596 | -122.460629072691 | (37.7480605390596, -122.460629072691) | |||
72785 | 72785 | 136545 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1127 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6006847.68823 | 2114784.64257 | 37.78718235392171 | -122.42009615501301 | (37.7871823539217, -122.420096155013) | |||
73051 | 73051 | 249429 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 601 Eddy St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6007371.4377 | 2113305.12395 | 37.7831494521267 | -122.41817915746599 | (37.7831494521267, -122.418179157466) | |||
74861 | 74861 | 249430 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 601 Eddy St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6007422.07723 | 2113312.26765 | 37.783171917193705 | -122.418004471327 | (37.7831719171937, -122.418004471327) | |||
76054 | 76054 | 179588 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 71 South Hill Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6002920.320730001 | 2087190.6404400002 | 37.711193657325204 | -122.43171310439199 | (37.7111936573252, -122.431713104392) | |||
120055 | 120055 | 136561 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1338 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6007220.04731 | 2115970.84797 | 37.7904603549 | -122.41889203203999 | (37.7904603549, -122.41889203204) | |||
121241 | 121241 | 136571 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2617 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6008282.41711 | 2121963.57618 | 37.8069746569262 | -122.41564077419599 | (37.8069746569262, -122.415640774196) | |||
121900 | 121900 | 136536 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2040 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6001917.77213 | 2115651.75647 | 37.7892842269232 | -122.437214676436 | (37.7892842269232, -122.437214676436) | |||
129799 | 129799 | 245291 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1543 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6002046.84387 | 2099517.48848 | 37.744990830965904 | -122.435613365186 | (37.7449908309659, -122.435613365186) | |||
130951 | 130951 | 245296 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 525 Day St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 4ft | 6002501.124969999 | 2098560.28004 | 37.7423883521338 | -122.433974135799 | (37.7423883521338, -122.433974135799) | |||
132235 | 132235 | 136573 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2617 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6008287.6646 | 2121918.27349 | 37.8068505621804 | -122.415619404506 | (37.8068505621804, -122.415619404506) | |||
132999 | 132999 | 136569 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2617 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6008276.62811 | 2122005.04702 | 37.8070881999362 | -122.41566374648599 | (37.8070881999362, -122.415663746486) | |||
133124 | 133124 | 136547 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1127 Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6006861.9768199995 | 2114694.93906 | 37.7869368551843 | -122.42004035118 | (37.7869368551843, -122.42004035118) | |||
133966 | 133966 | 136543 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1177 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6006827.654019999 | 2114934.96307 | 37.7875939682209 | -122.42017614161101 | (37.7875939682209, -122.420176141611) | |||
134852 | 134852 | 136544 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1177 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6006828.33355 | 2114915.6748599997 | 37.7875410458324 | -122.42017242113998 | (37.7875410458324, -122.42017242114) | |||
146114 | 146114 | 245278 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1779 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6008034.93749 | 2108017.16793 | 37.768667305872896 | -122.41550920878599 | (37.7686673058729, -122.415509208786) | |||
150567 | 150567 | 136552 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 535 Post St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009695.68796 | 2115014.2038 | 37.787972726715296 | -122.410258865966 | (37.7879727267153, -122.410258865966) | |||
151041 | 151041 | 245265 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 367 27th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 4ft | 6004173.64984 | 2100117.18902 | 37.7467580401513 | -122.42830198666 | (37.7467580401513, -122.42830198666) | |||
151553 | 151553 | 246452 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 405 Duncan St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6003797.20861 | 2099802.06763 | 37.7458714821788 | -122.429581212917 | (37.7458714821788, -122.429581212917) | |||
151792 | 151792 | 136550 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 535 Post St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009600.17955 | 2115001.02836 | 37.7879311960125 | -122.410588378478 | (37.7879311960125, -122.410588378478) | |||
153682 | 153682 | 136574 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 145 Jefferson St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6008546.664059999 | 2122423.8020200003 | 37.8082531709192 | -122.414758881938 | (37.8082531709192, -122.414758881938) | |||
153842 | 153842 | 136542 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1234 Polk St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 6006831.91851 | 2115273.7741900003 | 37.7885245003562 | -122.4201854424 | (37.7885245003562, -122.4201854424) | |||
156434 | 156434 | 136548 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1160 Polk St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 6006881.24187 | 2114926.3678900003 | 37.7875733872447 | -122.419990127669 | (37.7875733872447, -122.419990127669) | |||
158038 | 158038 | 136546 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1127 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006858.02887 | 2114712.1526099998 | 37.7869838969287 | -122.420055232258 | (37.7869838969287, -122.420055232258) | |||
158193 | 158193 | 249428 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 601 Eddy St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6007312.28325 | 2113298.00589 | 37.78312657787821 | -122.418383303558 | (37.7831265778782, -122.418383303558) | |||
159149 | 159149 | 245270 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 217 Ogden Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 6008469.38018 | 2096081.82055 | 37.7359199396575 | -122.413162421625 | (37.7359199396575, -122.413162421625) | |||
159847 | 159847 | 248022 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 501 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6009976.68855 | 2098377.46045 | 37.7423077764783 | -122.408112883923 | (37.7423077764783, -122.408112883923) | |||
160193 | 160193 | 245352 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 87 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6003112.84952 | 2105613.2672099997 | 37.761788885269205 | -122.43236259925101 | (37.7617888852692, -122.432362599251) | |||
161545 | 161545 | 136570 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2617 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6008280.33532 | 2121982.52726 | 37.8070265747706 | -122.415649321353 | (37.8070265747706, -122.415649321353) | |||
162045 | 162045 | 245290 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1543 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 4ft | 6002048.52653 | 2099498.08417 | 37.7449376468641 | -122.435606158916 | (37.7449376468641, -122.435606158916) | |||
162291 | 162291 | 136538 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2960 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5999433.58681 | 2117034.92752 | 37.792940523231394 | -122.445909151991 | (37.7929405232314, -122.445909151991) | |||
163232 | 163232 | 197774 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1601 Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6012501.40627 | 2106077.71632 | 37.7635920466475 | -122.39992373560301 | (37.7635920466475, -122.399923735603) | |||
163727 | 163727 | 215159 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 18 Sargent St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5993985.26424 | 2089201.7814099998 | 37.7162052463581 | -122.462740441625 | (37.7162052463581, -122.462740441625) | |||
163984 | 163984 | 136549 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1160 Polk St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 6006876.35083 | 2114950.02533 | 37.787638069192205 | -122.420008729221 | (37.7876380691922, -122.420008729221) | |||
167427 | 167427 | 136556 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 100 Cedar St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6006852.77873 | 2114483.71843 | 37.786356376980706 | -122.420057179305 | (37.7863563769807, -122.420057179305) | |||
168832 | 168832 | 245295 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 525 Day St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 4ft | 6002502.037219999 | 2098563.6200099997 | 37.7423975746843 | -122.433971220207 | (37.7423975746843, -122.433971220207) | |||
169346 | 169346 | 136551 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 535 Post St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009633.52573 | 2115005.6617 | 37.7879457875105 | -122.410473333578 | (37.7879457875105, -122.410473333578) | |||
170732 | 170732 | 136572 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2617 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008286.12433 | 2121941.05643 | 37.806913031784504 | -122.41562634907 | (37.8069130317845, -122.41562634907) | |||
170994 | 170994 | 136539 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2960 Broadway | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 5999446.05999 | 2117049.87751 | 37.7929822841634 | -122.44586707000299 | (37.7929822841634, -122.445867070003) | |||
176603 | 176603 | 136555 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 100 Cedar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6006874.57787 | 2114487.0344700003 | 37.7863667101899 | -122.419981995093 | (37.7863667101899, -122.419981995093) | |||
176858 | 176858 | 245277 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2394 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6008165.09675 | 2104533.2431900003 | 37.7591085701264 | -122.414812397888 | (37.7591085701264, -122.414812397888) | |||
182388 | 182388 | 136541 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1234 Polk St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6006833.25641 | 2115260.3621400003 | 37.7884877495592 | -122.42017986121701 | (37.7884877495592, -122.420179861217) | |||
185206 | 185206 | 122033 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 643 18th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 5990312.98085 | 2110983.69674 | 37.7758005234202 | -122.47702420793199 | (37.7758005234202, -122.477024207932) | |||
187528 | 187528 | 136540 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2960 Broadway | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5999430.14581 | 2117046.26527 | 37.7929714572124 | -122.44592187379601 | (37.7929714572124, -122.445921873796) | |||
188267 | 188267 | 136535 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2040 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6001921.861880001 | 2115620.94722 | 37.7891998651308 | -122.43719831956999 | (37.7891998651308, -122.43719831957) |
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");