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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
109122 | 109122 | 117509 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 300x HANOVER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999715.0 | 2086521.0 | 37.7091727618039 | -122.442743399736 | (37.7091727618039, -122.442743399736) | ||||
185534 | 185534 | 176074 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 786 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001892.13578 | 2089268.05693 | 37.7168394482606 | -122.435415271495 | (37.7168394482606, -122.435415271495) | |||
77159 | 77159 | 176073 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 774 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001923.16259 | 2089317.3719 | 37.7169766182659 | -122.43531155267999 | (37.7169766182659, -122.43531155268) | |||
3387 | 3387 | 161273 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 566 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 0 | Width 0ft | 6002889.180369999 | 2090346.5289900003 | 37.719857269085104 | -122.432045948864 | (37.7198572690851, -122.432045948864) | ||
42780 | 42780 | 200073 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1500 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6014933.989 | 2093151.8218 | 37.7282355589188 | -122.390606833955 | (37.7282355589188, -122.390606833955) | |||
175342 | 175342 | 200074 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1500 Van Dyke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6014921.0644 | 2093162.4986 | 37.728264158228896 | -122.39065226097 | (37.7282641582289, -122.39065226097) | |||
116485 | 116485 | 200075 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1500 Van Dyke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6014900.2728 | 2093175.985 | 37.7283000356482 | -122.390725081061 | (37.7283000356482, -122.390725081061) | |||
36442 | 36442 | 200076 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1500 Van Dyke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6014887.9102 | 2093187.7857 | 37.728331752097795 | -122.390768643797 | (37.7283317520978, -122.390768643797) | |||
135298 | 135298 | 176075 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 100 Capistrano Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001444.800340001 | 2093622.381 | 37.7287700227166 | -122.43727309280001 | (37.7287700227166, -122.4372730928) | |||
33049 | 33049 | 206535 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 665 Miramar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995362.41808 | 2093767.65006 | 37.7288212525964 | -122.458310655534 | (37.7288212525964, -122.458310655534) | |||
171923 | 171923 | 206534 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 665 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995362.10243 | 2093779.40423 | 37.7288535085691 | -122.45831259717501 | (37.7288535085691, -122.458312597175) | |||
25122 | 25122 | 206533 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 665 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995361.50595 | 2093791.16395 | 37.7288857636427 | -122.45831551006201 | (37.7288857636427, -122.458315510062) | |||
161050 | 161050 | 199671 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1905 Keith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015210.0019 | 2093419.3228 | 37.728985371993396 | -122.389671313679 | (37.7289853719934, -122.389671313679) | |||
166442 | 166442 | 206532 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993345.963169999 | 2094536.94274 | 37.730817459756 | -122.46533747775 | (37.730817459756, -122.46533747775) | |||
70255 | 70255 | 206531 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993348.57217 | 2094559.38972 | 37.730879244086296 | -122.46533008801399 | (37.7308792440863, -122.465330088014) | |||
35567 | 35567 | 206696 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 230 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000774.6257 | 2094855.9884099998 | 37.7321191034008 | -122.439678327791 | (37.7321191034008, -122.439678327791) | |||
61039 | 61039 | 206671 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 370 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995266.43425 | 2095204.88442 | 37.732762033223 | -122.45874648408899 | (37.732762033223, -122.458746484089) | |||
119316 | 119316 | 206672 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 370 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995263.98331 | 2095214.4393900002 | 37.732788127968995 | -122.458755649049 | (37.732788127969, -122.458755649049) | |||
181759 | 181759 | 206559 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 355 Yerba Buena Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5995306.63453 | 2095221.10602 | 37.7328088843117 | -122.458608676455 | (37.7328088843117, -122.458608676455) | |||
29986 | 29986 | 206673 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 370 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995261.57654 | 2095226.1050200001 | 37.7328200206111 | -122.45876481406201 | (37.7328200206111, -122.458764814062) | |||
30299 | 30299 | 206560 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 355 Yerba Buena Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995304.48103 | 2095229.25095 | 37.7328311245367 | -122.458616711016 | (37.7328311245367, -122.458616711016) | |||
30345 | 30345 | 206561 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 355 Yerba Buena Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5995302.34368 | 2095238.1668900002 | 37.732855482695 | -122.458624745542 | (37.732855482695, -122.458624745542) | |||
165652 | 165652 | 206674 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 300 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995208.64941 | 2095407.77696 | 37.7333158051714 | -122.458960944512 | (37.7333158051714, -122.458960944512) | |||
188288 | 188288 | 206675 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 300 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995199.651459999 | 2095433.83543 | 37.733386838132 | -122.458993938825 | (37.733386838132, -122.458993938825) | |||
183187 | 183187 | 206695 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 140 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001321.914580001 | 2095363.51303 | 37.7335437842173 | -122.437822570471 | (37.7335437842173, -122.437822570471) | |||
157023 | 157023 | 206694 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 125 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001630.15209 | 2095380.35715 | 37.733607556928 | -122.43675811218999 | (37.733607556928, -122.43675811219) | |||
51664 | 51664 | 206697 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998934.9538199995 | 2095541.69667 | 37.733897014518206 | -122.446087759167 | (37.7338970145182, -122.446087759167) | |||
36687 | 36687 | 206698 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998920.6207 | 2095542.64427 | 37.7338987978865 | -122.446137381059 | (37.7338987978865, -122.446137381059) | |||
33508 | 33508 | 206699 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998907.63682 | 2095545.7294400001 | 37.7339065275492 | -122.44618249194599 | (37.7339065275492, -122.446182491946) | |||
160923 | 160923 | 206700 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998900.2822900005 | 2095547.61505 | 37.7339112849776 | -122.446208054284 | (37.7339112849776, -122.446208054284) | |||
87649 | 87649 | 121661 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
96465 | 96465 | 121662 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
118078 | 118078 | 121664 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
126565 | 126565 | 121663 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
142340 | 142340 | 121660 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
40516 | 40516 | 206701 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998876.80466 | 2095558.4978900002 | 37.733939825858606 | -122.446290005877 | (37.7339398258586, -122.446290005877) | |||
134815 | 134815 | 206702 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998869.22619 | 2095565.73707 | 37.733959270110795 | -122.446316727449 | (37.7339592701108, -122.446316727449) | |||
72707 | 72707 | 190928 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1778 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014320.53257 | 2095360.07162 | 37.73426491189 | -122.39288202418301 | (37.73426491189, -122.392882024183) | |||
179932 | 179932 | 206676 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 240 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994971.50428 | 2095856.22795 | 37.7345335069973 | -122.459813287749 | (37.7345335069973, -122.459813287749) | |||
66473 | 66473 | 206691 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 582 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5996439.41867 | 2095873.6949599998 | 37.734665775709296 | -122.45473950971599 | (37.7346657757093, -122.454739509716) | |||
151039 | 151039 | 206692 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 582 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996416.06092 | 2095880.8714400001 | 37.7346841407625 | -122.45482078325199 | (37.7346841407625, -122.454820783252) | |||
177940 | 177940 | 206677 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 228 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994904.4684 | 2095946.32835 | 37.7347770452256 | -122.46005157662901 | (37.7347770452256, -122.460051576629) | |||
165826 | 165826 | 206688 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 629 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996101.05251 | 2095948.39142 | 37.7348514596286 | -122.455914747394 | (37.7348514596286, -122.455914747394) | |||
58097 | 58097 | 206689 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 616 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996145.20311 | 2095954.15677 | 37.734869823774 | -122.45576252094901 | (37.734869823774, -122.455762520949) | |||
151724 | 151724 | 206687 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 629 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996087.4467400005 | 2095957.96527 | 37.7348769661929 | -122.45596247889 | (37.7348769661929, -122.45596247889) | |||
72284 | 72284 | 206690 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 616 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996131.5818 | 2095962.98776 | 37.7348932897948 | -122.45581025245001 | (37.7348932897948, -122.45581025245) | |||
188155 | 188155 | 206686 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 629 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996075.5527099995 | 2095969.20127 | 37.7349071348466 | -122.456004412496 | (37.7349071348466, -122.456004412496) | |||
42708 | 42708 | 206685 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 641 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996053.59921 | 2095980.96691 | 37.734938180348 | -122.45608116333099 | (37.734938180348, -122.456081163331) | |||
50876 | 50876 | 206684 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 647 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996011.49185 | 2096001.54035 | 37.7349922529962 | -122.456228229446 | (37.7349922529962, -122.456228229446) | |||
66495 | 66495 | 206683 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 647 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995995.17419 | 2096006.3401799998 | 37.7350044954584 | -122.45628499197399 | (37.7350044954584, -122.456284991974) | |||
34880 | 34880 | 206682 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 647 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995986.285069999 | 2096009.4987 | 37.7350126577011 | -122.45631595293699 | (37.7350126577011, -122.456315952937) | |||
160214 | 160214 | 206681 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 657 Los Palmos Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995960.60425 | 2096012.63655 | 37.735019799206 | -122.45640496693399 | (37.735019799206, -122.456404966934) | |||
167831 | 167831 | 206678 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 657 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995925.9256 | 2096013.7330599998 | 37.7350208190394 | -122.456524941888 | (37.7350208190394, -122.456524941888) | |||
155591 | 155591 | 206679 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 657 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995939.36036 | 2096013.8239 | 37.7350218397738 | -122.456478499997 | (37.7350218397738, -122.456478499997) | |||
66828 | 66828 | 206680 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 657 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995948.68471 | 2096013.6289400002 | 37.73502183977529 | -122.456446248507 | (37.7350218397753, -122.456446248507) | |||
63545 | 63545 | 223038 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 10 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002089.19721 | 2096067.16423 | 37.7355194490575 | -122.435220170783 | (37.7355194490575, -122.435220170783) | |||
158004 | 158004 | 223037 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 203 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002071.560219999 | 2096098.27883 | 37.7356038810064 | -122.435283373351 | (37.7356038810064, -122.435283373351) | |||
126743 | 126743 | 223043 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 4107 Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008381.78974 | 2096055.8705400003 | 37.735843768863795 | -122.413463422917 | (37.7358437688638, -122.413463422917) | |||
174269 | 174269 | 223032 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 281 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006256.18709 | 2096109.4549 | 37.735871320489395 | -122.42081628443898 | (37.7358713204894, -122.420816284439) | |||
162977 | 162977 | 223033 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 281 Richland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006248.27078 | 2096110.4955099998 | 37.735873731571395 | -122.420843728155 | (37.7358737315714, -122.420843728155) | |||
69745 | 69745 | 223042 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 330 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006921.22556 | 2096271.82147 | 37.736354605390204 | -122.418528488295 | (37.7363546053902, -122.418528488295) | |||
155564 | 155564 | 223055 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 42 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002598.631 | 2096412.43412 | 37.7364963969952 | -122.433483533142 | (37.7364963969952, -122.433483533142) | |||
60482 | 60482 | 247587 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 800 Tompkins Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6008949.04431 | 2096428.8077599998 | 37.7368996080238 | -122.41152853331499 | (37.7368996080238, -122.411528533315) | ||||
63732 | 63732 | 247588 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 800 Tompkins Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6008943.011630001 | 2096440.0672900002 | 37.7369301858647 | -122.411550186315 | (37.7369301858647, -122.411550186315) | ||||
25265 | 25265 | 223034 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 578 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007664.494030001 | 2096661.03983 | 37.7374651296141 | -122.41598624606199 | (37.7374651296141, -122.415986246062) | |||
39350 | 39350 | 223040 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 567 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007699.61186 | 2096703.5074099998 | 37.7375837106174 | -122.41586783322799 | (37.7375837106174, -122.415867833228) | |||
132461 | 132461 | 206523 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2690 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991790.63989 | 2097130.86053 | 37.737849885658 | -122.470903312649 | (37.737849885658, -122.470903312649) | |||
168058 | 168058 | 223039 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 543 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007708.387180001 | 2096815.6091900002 | 37.7378920108046 | -122.41584542843201 | (37.7378920108046, -122.415845428432) | |||
186945 | 186945 | 206566 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2679 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991741.264830001 | 2097200.972 | 37.738039538296206 | -122.471079130991 | (37.7380395382962, -122.471079130991) | |||
75089 | 75089 | 206565 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2679 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991740.0000599995 | 2097213.7223099996 | 37.7380744742606 | -122.471084432514 | (37.7380744742606, -122.471084432514) | |||
74097 | 74097 | 223041 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 410 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007256.618290001 | 2097259.39898 | 37.7390851512711 | -122.41743886071899 | (37.7390851512711, -122.417438860719) | |||
129639 | 129639 | 223056 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 191 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004346.640459999 | 2097517.13802 | 37.739628683514496 | -122.427518598925 | (37.7396286835145, -122.427518598925) | |||
25343 | 25343 | 183040 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2562 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5989885.4338 | 2097934.2198 | 37.739945333152 | -122.477549168466 | (37.739945333152, -122.477549168466) | |||
149027 | 149027 | 206693 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 609 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997804.54909 | 2098010.1173 | 37.740610086694396 | -122.45017375511999 | (37.7406100866944, -122.45017375512) | |||
185359 | 185359 | 206567 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2523 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991381.7608900005 | 2098233.80223 | 37.74085462674589 | -122.472397375252 | (37.7408546267459, -122.472397375252) | |||
75714 | 75714 | 206568 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2515 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991380.56657 | 2098286.2467799997 | 37.7409985569439 | -122.472405327055 | (37.7409985569439, -122.472405327055) | |||
2031 | 2031 | 251786 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 300 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195.0 | 2098242.0 | 37.7417233638646 | -122.42117921336501 | (37.7417233638646, -122.421179213365) | ||
150656 | 150656 | 247816 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 550 30th St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6003030.78831 | 2098349.34835 | 37.741839226995204 | -122.43212766126899 | (37.7418392269952, -122.432127661269) | |||
171063 | 171063 | 206569 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2435 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992009.07535 | 2098867.5883299997 | 37.7426311295378 | -122.47027451837099 | (37.7426311295378, -122.470274518371) | |||
74719 | 74719 | 206524 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 35 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992940.67499 | 2098878.9332 | 37.742716096581894 | -122.467054169341 | (37.7427160965819, -122.467054169341) | |||
26843 | 26843 | 206525 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 35 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992946.5083 | 2098897.01812 | 37.7427660898953 | -122.46703531413 | (37.7427660898953, -122.46703531413) | |||
50429 | 50429 | 206526 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 35 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992953.91132 | 2098913.47299 | 37.742811698104205 | -122.467010912843 | (37.7428116981042, -122.467010912843) | |||
132226 | 132226 | 206527 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 13 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992983.90563 | 2098997.49136 | 37.7430441224891 | -122.46691330850099 | (37.7430441224891, -122.466913308501) | |||
50360 | 50360 | 206528 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 13 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992986.65204 | 2099006.05822 | 37.7430678034305 | -122.466904434898 | (37.7430678034305, -122.466904434898) | |||
148248 | 148248 | 206529 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 13 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992989.732419999 | 2099015.25675 | 37.7430932380525 | -122.466894452432 | (37.7430932380525, -122.466894452432) | |||
553 | 553 | 206616 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 779324 | 5994742.56026 | 2099334.6803900003 | 37.7440713065495 | -122.460856833195 | (37.7440713065495, -122.460856833195) | ||
9865 | 9865 | 122387 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779324 | 5994732.0 | 2099337.0 | 37.7440770679838 | -122.460893516037 | (37.7440770679838, -122.460893516037) | |||
539 | 539 | 206615 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 779324 | 5994758.52704 | 2099346.29484 | 37.7441041156281 | -122.460802465585 | (37.7441041156281, -122.460802465585) | ||
565 | 565 | 206617 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Garcia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994686.63181 | 2099351.09779 | 37.7441131663853 | -122.461051409618 | (37.7441131663853, -122.461051409618) | |||
571 | 571 | 206618 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Garcia Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | Permit Number 779324 | 5994673.79551 | 2099409.87557 | 37.7442738167873 | -122.461100053935 | (37.7442738167873, -122.461100053935) | ||
161600 | 161600 | 206530 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 175 Garcia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994631.6545 | 2099433.40276 | 37.744335991408896 | -122.46124747260099 | (37.7443359914089, -122.461247472601) | |||
55179 | 55179 | 184366 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2295 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5987606.9921 | 2099709.6419 | 37.7446876937291 | -122.485557233352 | (37.7446876937291, -122.485557233352) | |||
56319 | 56319 | 206573 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 51 Cortes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993216.90415 | 2099626.41246 | 37.7447844257663 | -122.466153363383 | (37.7447844257663, -122.466153363383) | |||
47868 | 47868 | 206574 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 120 Montalvo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993698.095930001 | 2099619.5133 | 37.744793232835605 | -122.464489006068 | (37.7447932328356, -122.464489006068) | |||
153258 | 153258 | 206575 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 120 Montalvo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993692.18131 | 2099632.63233 | 37.744828913423 | -122.464510409921 | (37.744828913423, -122.464510409921) | |||
23989 | 23989 | 206572 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 51 Cortes Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993215.16949 | 2099646.04946 | 37.7448382439064 | -122.466160788211 | (37.7448382439064, -122.466160788211) | |||
45428 | 45428 | 206576 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 100 Montalvo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993684.51151 | 2099645.64672 | 37.744864205510204 | -122.46453787523501 | (37.7448642055102, -122.464537875235) | |||
40559 | 40559 | 206571 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 51 Cortes Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993219.180819999 | 2099666.63445 | 37.7448949964991 | -122.466148413523 | (37.7448949964991, -122.466148413523) | |||
62866 | 62866 | 206570 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 4 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993230.1067699995 | 2099675.67045 | 37.7449204374235 | -122.46611129043 | (37.7449204374235, -122.46611129043) | |||
30002 | 30002 | 206592 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 101 Montalvo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993721.8716 | 2099672.6551599996 | 37.744940517497 | -122.464410652624 | (37.744940517497, -122.464410652624) |
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");