trees
336 rows where qLegalStatus_id = 1 and qSpecies_id = 133 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8606 | 190946 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 40 Bluxome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6013405.51497 | 2110852.0091 | 37.7767515500726 | -122.397131477343 | (37.7767515500726, -122.397131477343) | 6 | 2 | 9 | 28856 | 34 | |||
86236 | 190926 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1303 Rhode Island St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6012003.88758 | 2102215.75937 | 37.7529602155494 | -122.401373086604 | (37.7529602155494, -122.401373086604) | 10 | 3 | 8 | 28856 | 29 | |||
124900 | 190927 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1050 Wisconsin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6012767.00645 | 2102579.68997 | 37.7540020378723 | -122.39875959738 | (37.7540020378723, -122.39875959738) | 10 | 3 | 8 | 28856 | 29 | |||
158231 | 190925 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 651 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011562.19337 | 2105343.91486 | 37.761524784975 | -122.40312057635 | (37.761524784975, -122.40312057635) | 10 | 3 | 8 | 28856 | 29 | |||
8188 | 126379 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1136 Havens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6007507.74968 | 2119357.27743 | 37.7997748437807 | -122.418136782297 | (37.7997748437807, -122.418136782297) | 5 | 1 | 1 | 28858 | 32 | |||
52088 | 126383 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1116 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 4 | 6007504.98606 | 2119897.57415 | 37.801258207159 | -122.418184672095 | (37.801258207159, -122.418184672095) | 5 | 1 | 1 | 28858 | 32 | ||||
164255 | 126380 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1136 Havens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6007510.81799 | 2119357.46903 | 37.7997755425663 | -122.418126178374 | (37.7997755425663, -122.418126178374) | 5 | 1 | 1 | 28858 | 32 | |||
184572 | 50986 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1120REVISED Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2004 12:00:00 AM | 6 | Permit Number 47576 | 6007503.31376 | 2119893.93908 | 37.801248132044 | -122.418190201138 | (37.801248132044, -122.418190201138) | 5 | 1 | 1 | 28858 | 32 | ||
187759 | 126384 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1120 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 4 | 6007500.24433 | 2119896.23774 | 37.8012542708165 | -122.418200985801 | (37.8012542708165, -122.418200985801) | 5 | 1 | 1 | 28858 | 32 | ||||
4563 | 223021 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 109 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006234.71683 | 2099501.18451 | 37.7451830394575 | -122.421131274692 | (37.7451830394575, -122.421131274692) | 2 | 7 | 7 | 28859 | 2 | |||
5637 | 223045 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008341.10325 | 2099446.02772 | 37.7451501107949 | -122.413843827126 | (37.7451501107949, -122.413843827126) | 2 | 7 | 7 | 28859 | 2 | |||
25370 | 28296 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1432 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2003 12:00:00 AM | 6 | 2X3 | 6005818.9272 | 2100626.68333 | 37.7482499542668 | -122.422648971496 | (37.7482499542668, -122.422648971496) | 2 | 4 | 5 | 28859 | 19 | ||
26895 | 24597 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 451 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1996 12:00:00 AM | 6 | 3X3 | 6007425.33634 | 2097280.23764 | 37.7391518611665 | -122.416856984981 | (37.7391518611665, -122.416856984981) | 2 | 7 | 7 | 28859 | 2 | ||
27447 | 223034 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 578 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007664.49403 | 2096661.03983 | 37.7374651296141 | -122.415986246062 | (37.7374651296141, -122.415986246062) | 2 | 7 | 7 | 28859 | 2 | |||
32772 | 255586 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 157 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006708 | 2105213 | 37.760893044988 | -122.419899978675 | (37.760893044988, -122.419899978675) | 2 | 4 | 7 | 28859 | 19 | ||||
40601 | 223023 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 330 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006515.40022 | 2104174.73701 | 37.7580313639845 | -122.420492397202 | (37.7580313639845, -122.420492397202) | 2 | 4 | 7 | 28859 | 19 | |||
44249 | 24588 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 820 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/1996 12:00:00 AM | 20 | 3X3 | 6008195.26733 | 2097153.24719 | 37.7388464504963 | -122.414185921141 | (37.7388464504963, -122.414185921141) | 2 | 7 | 7 | 28859 | 2 | ||
52294 | 28791 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2737 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008967.21311 | 2102509.30076 | 37.7535963186214 | -122.411895265148 | (37.7535963186214, -122.411895265148) | 2 | 4 | 7 | 28859 | 19 | |||
54373 | 223035 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 99 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008263.26696 | 2099462.20339 | 37.7451901540099 | -122.414114116572 | (37.7451901540099, -122.414114116572) | 2 | 7 | 7 | 28859 | 2 | |||
70202 | 223024 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 979 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009975.92603 | 2103539.78877 | 37.756482348292 | -122.408479582484 | (37.756482348292, -122.408479582484) | 2 | 4 | 7 | 28859 | 19 | |||
70967 | 28792 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2731 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008964.24348 | 2102548.86607 | 37.7537047894643 | -122.411908330514 | (37.7537047894643, -122.411908330514) | 2 | 4 | 7 | 28859 | 19 | |||
85167 | 223025 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 380 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005467.6636 | 2101500.58617 | 37.7506296665394 | -122.423925765973 | (37.7506296665394, -122.423925765973) | 2 | 4 | 5 | 28859 | 19 | |||
86127 | 32398 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 244 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 8 | Permit Number 36939 | 6005971.23324 | 2096091.59209 | 37.7358062077876 | -122.421800215602 | (37.7358062077876, -122.421800215602) | 2 | 7 | 7 | 28859 | 2 | |
92618 | 223022 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 101 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6006257.51967 | 2099541.04409 | 37.7452937702941 | -122.42105525589 | (37.7452937702941, -122.42105525589) | 2 | 7 | 7 | 28859 | 2 | |||
101700 | 247588 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 800 Tompkins Ave | 9 | Front Yard : Yard | Tree | Private 2 | 6 | 6008943.01163 | 2096440.06729 | 37.7369301858647 | -122.411550186315 | (37.7369301858647, -122.411550186315) | 10 | 7 | 7 | 28859 | 2 | ||||
114823 | 223042 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 330 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006921.22556 | 2096271.82147 | 37.7363546053902 | -122.418528488295 | (37.7363546053902, -122.418528488295) | 2 | 7 | 7 | 28859 | 2 | |||
116102 | 223039 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 543 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007708.38718 | 2096815.60919 | 37.7378920108046 | -122.415845428432 | (37.7378920108046, -122.415845428432) | 2 | 7 | 7 | 28859 | 2 | |||
116769 | 24553 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 404 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6007222.65374 | 2097265.29025 | 37.7390994163072 | -122.417556712385 | (37.7390994163072, -122.417556712385) | 2 | 7 | 7 | 28859 | 2 | |||
123656 | 223036 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2743 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008969.13541 | 2102480.10351 | 37.7535162573804 | -122.411886554326 | (37.7535162573804, -122.411886554326) | 2 | 4 | 7 | 28859 | 19 | |||
123767 | 223041 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 408 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | Permit Number 776709 | 6007256.61829 | 2097259.39898 | 37.7390851512711 | -122.417438860719 | (37.7390851512711, -122.417438860719) | 2 | 7 | 7 | 28859 | 2 | ||
133368 | 247587 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 800 Tompkins Ave | 8 | Front Yard : Yard | Tree | Private 2 | 6 | 6008949.04431 | 2096428.80776 | 37.7368996080238 | -122.411528533315 | (37.7368996080238, -122.411528533315) | 10 | 7 | 7 | 28859 | 2 | ||||
137974 | 24556 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 416 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6007294.81147 | 2097256.19199 | 37.739078494466 | -122.417306578558 | (37.739078494466, -122.417306578558) | 2 | 7 | 7 | 28859 | 2 | |||
139743 | 223040 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 567 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007699.61186 | 2096703.50741 | 37.7375837106174 | -122.415867833228 | (37.7375837106174, -122.415867833228) | 2 | 7 | 7 | 28859 | 2 | |||
142812 | 24587 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 804 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/1996 12:00:00 AM | 18 | 3X3 | 6008146.87115 | 2097150.77398 | 37.738836941075 | -122.414353078142 | (37.738836941075, -122.414353078142) | 2 | 7 | 7 | 28859 | 2 | ||
149638 | 223046 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 77 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005471.50149 | 2099604.561 | 37.7454238329391 | -122.423777694396 | (37.7454238329391, -122.423777694396) | 2 | 7 | 5 | 28859 | 22 | |||
151854 | 223032 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 281 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006256.18709 | 2096109.4549 | 37.7358713204894 | -122.420816284439 | (37.7358713204894, -122.420816284439) | 2 | 7 | 7 | 28859 | 2 | |||
155068 | 255587 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 157 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006708 | 2105213 | 37.760893044988 | -122.419899978675 | (37.760893044988, -122.419899978675) | 2 | 4 | 7 | 28859 | 19 | ||||
157257 | 223043 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 4107 Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008381.78974 | 2096055.87054 | 37.7358437688638 | -122.413463422917 | (37.7358437688638, -122.413463422917) | 10 | 7 | 7 | 28859 | 2 | |||
171276 | 223044 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Stoneman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008324.57166 | 2099444.87133 | 37.7451460071793 | -122.413900908902 | (37.7451460071793, -122.413900908902) | 2 | 7 | 7 | 28859 | 2 | |||
177885 | 223020 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 125 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6006199.74889 | 2099432.38497 | 37.7449921601655 | -122.421247303447 | (37.7449921601655, -122.421247303447) | 2 | 7 | 7 | 28859 | 2 | |||
178314 | 223033 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 281 Richland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006248.27078 | 2096110.49551 | 37.7358737315714 | -122.420843728155 | (37.7358737315714, -122.420843728155) | 2 | 7 | 7 | 28859 | 2 | |||
178830 | 251786 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 300 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195 | 2098242 | 37.7417233638646 | -122.421179213365 | (37.7417233638646, -122.421179213365) | 2 | 7 | 7 | 28859 | 2 | ||
20331 | 95111 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 649 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54039 | 6001701.74477 | 2093288.67335 | 37.7278683408513 | -122.436360947301 | (37.7278683408513, -122.436360947301) | 9 | 7 | 6 | 28861 | 25 |
57524 | 47492 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 5 | Permit Number 45386 | 6001676.19021 | 2093232.03842 | 37.7277113821718 | -122.436445238065 | (37.7277113821718, -122.436445238065) | 9 | 7 | 6 | 28861 | 25 | |
99367 | 176074 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 786 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001892.13578 | 2089268.05693 | 37.7168394482606 | -122.435415271495 | (37.7168394482606, -122.435415271495) | 9 | 7 | 6 | 28861 | 5 | |||
122610 | 176075 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 100 Capistrano Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6001444.80034 | 2093622.381 | 37.7287700227166 | -122.4372730928 | (37.7287700227166, -122.4372730928) | 9 | 7 | 6 | 28861 | 25 | |||
124950 | 176073 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 774 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001923.16259 | 2089317.3719 | 37.7169766182659 | -122.43531155268 | (37.7169766182659, -122.43531155268) | 9 | 7 | 6 | 28861 | 5 | |||
126152 | 206533 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 665 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995361.50595 | 2093791.16395 | 37.7288857636427 | -122.458315510062 | (37.7288857636427, -122.458315510062) | 9 | 7 | 4 | 28861 | 40 | |||
128797 | 206534 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 665 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995362.10243 | 2093779.40423 | 37.7288535085691 | -122.458312597175 | (37.7288535085691, -122.458312597175) | 9 | 7 | 4 | 28861 | 40 | |||
136667 | 206535 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 665 Miramar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5995362.41808 | 2093767.65006 | 37.7288212525964 | -122.458310655534 | (37.7288212525964, -122.458310655534) | 9 | 7 | 4 | 28861 | 40 | |||
164008 | 95110 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 649 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 54039 | 6001693.52474 | 2093271.82828 | 37.7278216210543 | -122.436388158988 | (37.7278216210543, -122.436388158988) | 9 | 7 | 6 | 28861 | 25 |
174811 | 161273 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 566 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | Width 0ft | 6002889.18037 | 2090346.52899 | 37.7198572690851 | -122.432045948864 | (37.7198572690851, -122.432045948864) | 9 | 7 | 6 | 28861 | 5 | ||
25870 | 223054 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 701 Church St | 15 | Front Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6004339.17113 | 2104460.25399 | 37.7586924448242 | -122.428039072561 | (37.7586924448242, -122.428039072561) | 2 | 4 | 5 | 28862 | 3 | |||
65845 | 223047 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3864 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6004003.36703 | 2102490.39098 | 37.7532646621477 | -122.429059987437 | (37.7532646621477, -122.429059987437) | 2 | 4 | 5 | 28862 | 22 | |||
110897 | 223053 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 701 Church St | 13 | Front Yard : Yard | Tree | Private 2 | 4 | Width 3ft | 6004342.54387 | 2104435.23189 | 37.7586239308804 | -122.42802562499 | (37.7586239308804, -122.42802562499) | 2 | 4 | 5 | 28862 | 3 | |||
111061 | 223026 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 114 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004706.47094 | 2102901.67728 | 37.7544337331488 | -122.426657794828 | (37.7544337331488, -122.426657794828) | 2 | 4 | 5 | 28862 | 22 | |||
119257 | 223030 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 125 Belgrave Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5997950.67072 | 2104889.0935 | 37.7595064230002 | -122.450164233094 | (37.7595064230002, -122.450164233094) | 15 | 5 | 11 | 28862 | 12 | |||
132506 | 223049 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002666.83309 | 2105626.92623 | 37.7618010890622 | -122.433906166852 | (37.7618010890622, -122.433906166852) | 15 | 4 | 5 | 28862 | 3 | |||
171056 | 223027 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 116 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6004711.20676 | 2102860.50548 | 37.754320952762 | -122.426638485476 | (37.754320952762, -122.426638485476) | 2 | 4 | 5 | 28862 | 22 | |||
176527 | 223048 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3880 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6003922.51538 | 2102484.70879 | 37.7532444831531 | -122.429339183778 | (37.7532444831531, -122.429339183778) | 2 | 4 | 5 | 28862 | 22 | |||
111111 | 137657 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2167 TURK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999659.4785 | 2111881.8514 | 37.7788044135747 | -122.444756988886 | (37.7788044135747, -122.444756988886) | 15 | 5 | 11 | 29490 | 16 | |||
118642 | 137632 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2175 TURK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999619.2063 | 2111878.8056 | 37.7787937523144 | -122.444896086774 | (37.7787937523144, -122.444896086774) | 15 | 5 | 11 | 29490 | 16 | |||
1328 | 65972 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2090 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1990 12:00:00 AM | 2 | Permit Number 28996 | 5989155.2561 | 2101119.0911 | 37.7486477564753 | -122.480306841406 | (37.7486477564753, -122.480306841406) | 1 | 8 | 3 | 29491 | 35 | |
10338 | 31751 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2546 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35238 | 5989883.0648 | 2098033.3774 | 37.7402174568148 | -122.477564605136 | (37.7402174568148, -122.477564605136) | 1 | 8 | 3 | 29491 | 35 | |
12800 | 206586 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 360 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993997.55659 | 2099722.78299 | 37.7450940434634 | -122.463461028807 | (37.7450940434634, -122.463461028807) | 1 | 8 | 4 | 29491 | 40 | |||
13518 | 31915 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2287 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 4 | Permit Number 35339 | 5991692.93382 | 2099879.32999 | 37.745390829638 | -122.471441338374 | (37.745390829638, -122.471441338374) | 1 | 8 | 4 | 29491 | 40 | |
16321 | 206539 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 393 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994118.07071 | 2101419.5251 | 37.749759810788 | -122.463167407365 | (37.749759810788, -122.463167407365) | 1 | 8 | 4 | 29491 | 40 | |||
17056 | 206626 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 40 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994084.99265 | 2101862.22446 | 37.7509734449922 | -122.463313912312 | (37.7509734449922, -122.463313912312) | 1 | 8 | 4 | 29491 | 40 | |||
20290 | 206629 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 81 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994298.95446 | 2101835.26425 | 37.7509117433916 | -122.462572061571 | (37.7509117433916, -122.462572061571) | 1 | 8 | 4 | 29491 | 40 | |||
23516 | 50918 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2477 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | 3 | Permit Number 47420 | 5989820.2795 | 2098517.5722 | 37.7415432867093 | -122.477817075256 | (37.7415432867093, -122.477817075256) | 1 | 8 | 3 | 29491 | 35 | |
24681 | 206641 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 196 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994436.73351 | 2100801.00946 | 37.7480798753848 | -122.462020618849 | (37.7480798753848, -122.462020618849) | 1 | 8 | 4 | 29491 | 40 | |||
25644 | 206545 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 265 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5994446.42204 | 2100465.35227 | 37.747158803252 | -122.461962779858 | (37.747158803252, -122.461962779858) | 1 | 8 | 4 | 29491 | 40 | |||
25861 | 206613 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 432 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5995024.84981 | 2100327.10403 | 37.7468124923186 | -122.459952623323 | (37.7468124923186, -122.459952623323) | 1 | 8 | 4 | 29491 | 40 | |||
27348 | 206661 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 390 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994161.93741 | 2101486.33597 | 37.7499457833913 | -122.463020562465 | (37.7499457833913, -122.463020562465) | 1 | 8 | 4 | 29491 | 40 | |||
28527 | 206648 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994513.85188 | 2100887.12446 | 37.748320765087 | -122.461760191398 | (37.748320765087, -122.461760191398) | 1 | 8 | 4 | 29491 | 40 | |||
31183 | 206625 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 80 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994283.13326 | 2101793.571 | 37.7507963531822 | -122.46262374829 | (37.7507963531822, -122.46262374829) | 1 | 8 | 4 | 29491 | 40 | |||
32620 | 31228 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2651 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/1995 12:00:00 AM | 4 | Permit Number 34914 | 5991736.03785 | 2097377.43168 | 37.7385237494811 | -122.47111005511 | (37.7385237494811, -122.47111005511) | 1 | 8 | 4 | 29491 | 40 | |
33901 | 183040 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2562 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5989885.4338 | 2097934.2198 | 37.739945333152 | -122.477549168466 | (37.739945333152, -122.477549168466) | 1 | 8 | 3 | 29491 | 35 | |||
35026 | 206591 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 101 Montalvo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5993709.62503 | 2099698.37793 | 37.7450104397813 | -122.464454865994 | (37.7450104397813, -122.464454865994) | 1 | 8 | 4 | 29491 | 40 | |||
37635 | 206573 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993216.90415 | 2099626.41246 | 37.7447844257663 | -122.466153363383 | (37.7447844257663, -122.466153363383) | 1 | 8 | 4 | 29491 | 40 | |||
38300 | 206652 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994516.45103 | 2100943.31749 | 37.7484752065739 | -122.4617552775 | (37.7484752065739, -122.4617552775) | 1 | 8 | 4 | 29491 | 40 | |||
39404 | 206537 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 401 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994067.3294 | 2101503.80633 | 37.7499883024325 | -122.46334898679 | (37.7499883024325, -122.46334898679) | 1 | 8 | 4 | 29491 | 40 | |||
40090 | 206631 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 89 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994365.26522 | 2101880.85976 | 37.7510407556506 | -122.462346061026 | (37.7510407556506, -122.462346061026) | 1 | 8 | 4 | 29491 | 40 | |||
40920 | 206659 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994198.61036 | 2101541.1054 | 37.750098278721 | -122.462897719553 | (37.750098278721, -122.462897719553) | 1 | 8 | 4 | 29491 | 40 | |||
42334 | 206608 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2 Sola Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5994960.81371 | 2100721.5804 | 37.7478919422595 | -122.460202627649 | (37.7478919422595, -122.460202627649) | 1 | 8 | 4 | 29491 | 40 | |||
44186 | 206624 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 80 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994298.51296 | 2101800.25271 | 37.7508155851791 | -122.46257104893 | (37.7508155851791, -122.46257104893) | 1 | 8 | 4 | 29491 | 40 | |||
45301 | 206523 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2690 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991790.63989 | 2097130.86053 | 37.737849885658 | -122.470903312649 | (37.737849885658, -122.470903312649) | 1 | 8 | 4 | 29491 | 40 | |||
45592 | 206647 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994503.49405 | 2100867.53113 | 37.748266370491 | -122.461794587759 | (37.748266370491, -122.461794587759) | 1 | 8 | 4 | 29491 | 40 | |||
46206 | 206638 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 167 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994538.83302 | 2100858.65401 | 37.7482440304446 | -122.46167174395 | (37.7482440304446, -122.46167174395) | 1 | 8 | 4 | 29491 | 40 | |||
47724 | 184366 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2295 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5987606.9921 | 2099709.6419 | 37.7446876937291 | -122.485557233352 | (37.7446876937291, -122.485557233352) | 1 | 8 | 3 | 29491 | 35 | |||
48224 | 206660 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994227.71262 | 2101539.78712 | 37.7500963352778 | -122.462796987411 | (37.7500963352778, -122.462796987411) | 1 | 8 | 4 | 29491 | 40 | |||
49813 | 206568 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2515 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991380.56657 | 2098286.24678 | 37.7409985569439 | -122.472405327055 | (37.7409985569439, -122.472405327055) | 1 | 8 | 4 | 29491 | 40 | |||
50752 | 206547 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 120 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993889.30878 | 2099967.60077 | 37.7457600139093 | -122.463853094571 | (37.7457600139093, -122.463853094571) | 1 | 8 | 4 | 29491 | 40 | |||
52410 | 206639 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 175 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994510.39425 | 2100823.87441 | 37.7481468973818 | -122.461767562235 | (37.7481468973818, -122.461767562235) | 1 | 8 | 4 | 29491 | 40 | |||
52801 | 206552 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 308 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5994313.1172 | 2100803.87721 | 37.7480806317257 | -122.462448284279 | (37.7480806317257, -122.462448284279) | 1 | 8 | 4 | 29491 | 40 | |||
54562 | 206595 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 135 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5995084.10326 | 2100870.93077 | 37.7483091116899 | -122.459787117476 | (37.7483091116899, -122.459787117476) | 1 | 8 | 4 | 29491 | 40 | |||
54867 | 206505 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1965 10th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993138.76599 | 2102124.24037 | 37.7516383146611 | -122.466605072187 | (37.7516383146611, -122.466605072187) | 1 | 8 | 4 | 29491 | 12 | |||
55707 | 206642 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 196 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994408.53923 | 2100777.89876 | 37.7480147959636 | -122.462116437149 | (37.7480147959636, -122.462116437149) | 1 | 8 | 4 | 29491 | 40 | |||
56805 | 206593 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 187 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5995062.08104 | 2100706.46988 | 37.7478562769412 | -122.459851357851 | (37.7478562769412, -122.459851357851) | 1 | 8 | 4 | 29491 | 40 | |||
57243 | 206633 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 145 Castenada Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994552.30711 | 2100925.23177 | 37.7484276117632 | -122.461629977659 | (37.7484276117632, -122.461629977659) | 1 | 8 | 4 | 29491 | 40 |
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) );