trees
493 rows where qSpecies_id = 133 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
65048 | 30759 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1563 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 5 | Permit Number 48354 | 6014932.9973 | 2093776.0212 | 37.7299494300904 | -122.390653863275 | (37.7299494300904, -122.390653863275) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
66765 | 206560 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995304.48103 | 2095229.25095 | 37.7328311245367 | -122.458616711016 | (37.7328311245367, -122.458616711016) | 9 | 7 | 4 | 59 | 40 | |||
68672 | 206540 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 387 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994134.95664 | 2101369.7507 | 37.7496241156629 | -122.463105404514 | (37.7496241156629, -122.463105404514) | 1 | 8 | 4 | 29491 | 40 | |||
68821 | 206588 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 348 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994058.29292 | 2099782.40477 | 37.7452612490171 | -122.463255340382 | (37.7452612490171, -122.463255340382) | 1 | 8 | 4 | 29491 | 40 | |||
68840 | 206686 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996075.55271 | 2095969.20127 | 37.7349071348466 | -122.456004412496 | (37.7349071348466, -122.456004412496) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
70335 | 206597 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 150 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5995049.66416 | 2100868.50319 | 37.7483004655893 | -122.459906030335 | (37.7483004655893, -122.459906030335) | 1 | 8 | 4 | 29491 | 40 | |||
70495 | 206635 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 145 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994551.94388 | 2100907.90537 | 37.7483800169362 | -122.461629977657 | (37.7483800169362, -122.461629977657) | 1 | 8 | 4 | 29491 | 40 | |||
70530 | 206606 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Magellan Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5995035.92285 | 2100721.97488 | 37.747897345392 | -122.459942934033 | (37.747897345392, -122.459942934033) | 1 | 8 | 4 | 29491 | 40 | |||
70575 | 206546 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 265 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5994442.89418 | 2100449.8026 | 37.747115904674 | -122.461973851414 | (37.747115904674, -122.461973851414) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
70998 | 206529 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992989.73242 | 2099015.25675 | 37.7430932380525 | -122.466894452432 | (37.7430932380525, -122.466894452432) | 1 | 8 | 4 | 59 | 40 | |||
71121 | 206526 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 35 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992953.91132 | 2098913.47299 | 37.7428116981042 | -122.467010912843 | (37.7428116981042, -122.467010912843) | 1 | 8 | 4 | 59 | 40 | |||
72421 | 206678 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995925.9256 | 2096013.73306 | 37.7350208190394 | -122.456524941888 | (37.7350208190394, -122.456524941888) | 9 | 7 | 4 | 59 | 40 | |||
72896 | 206698 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998920.6207 | 2095542.64427 | 37.7338987978865 | -122.446137381059 | (37.7338987978865, -122.446137381059) | 9 | 7 | 4 | 59 | 40 | |||
72984 | 206596 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 135 Magellan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5995085.45283 | 2100859.88169 | 37.7482788513041 | -122.459781650511 | (37.7482788513041, -122.459781650511) | 1 | 8 | 4 | 29491 | 40 | |||
73036 | 206517 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5991060.29058 | 2104484.56084 | 37.7579989703891 | -122.473964824336 | (37.7579989703891, -122.473964824336) | 1 | 8 | 4 | 56 | 12 | |||
73935 | 206644 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994467.924 | 2100831.48615 | 37.7481653523681 | -122.46191497372 | (37.7481653523681, -122.46191497372) | 1 | 8 | 4 | 29491 | 40 | |||
74040 | 206590 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 340 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994099.18491 | 2099823.62069 | 37.745376773231 | -122.463116933812 | (37.745376773231, -122.463116933812) | 1 | 8 | 4 | 29491 | 40 | |||
74334 | 244873 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 49 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000342.3248 | 2109115.5777 | 37.7712478709156 | -122.442196132801 | (37.7712478709156, -122.442196132801) | 15 | 5 | 11 | 29492 | 9 | |||
74614 | 206528 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992986.65204 | 2099006.05822 | 37.7430678034305 | -122.466904434898 | (37.7430678034305, -122.466904434898) | 1 | 8 | 4 | 59 | 40 | |||
74617 | 206562 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1478 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994313.38923 | 2105462.92602 | 37.7608732027602 | -122.462785287235 | (37.7608732027602, -122.462785287235) | 1 | 5 | 11 | 56 | 12 | |||
76261 | 26484 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 154 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000987.64369 | 2098692.25572 | 37.7426647191989 | -122.439216742684 | (37.7426647191989, -122.439216742684) | 2 | 7 | 5 | 63 | 7 | |||
76572 | 223055 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 42 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002598.631 | 2096412.43412 | 37.7364963969952 | -122.433483533142 | (37.7364963969952, -122.433483533142) | 2 | 7 | 5 | 63 | 7 | |||
77327 | 206601 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995052.26314 | 2100785.00395 | 37.7480713471357 | -122.459890995496 | (37.7480713471357, -122.459890995496) | 1 | 8 | 4 | 29491 | 40 | |||
77345 | 206554 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 47 Sotelo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5993895.61602 | 2101166.11299 | 37.7490511881613 | -122.463918266634 | (37.7490511881613, -122.463918266634) | 1 | 8 | 4 | 29491 | 40 | |||
77503 | 206587 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 348 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994044.71238 | 2099771.06427 | 37.7452293284847 | -122.463301476481 | (37.7452293284847, -122.463301476481) | 1 | 8 | 4 | 29491 | 40 | |||
78570 | 206653 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 150 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5994496.6283 | 2101014.48441 | 37.748669471824 | -122.46182898323 | (37.748669471824, -122.46182898323) | 1 | 8 | 4 | 29491 | 40 | |||
79407 | 206634 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 145 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994552.46207 | 2100915.67701 | 37.748401385725 | -122.461628749166 | (37.748401385725, -122.461628749166) | 1 | 8 | 4 | 29491 | 40 | |||
79608 | 206693 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 609 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997804.54909 | 2098010.1173 | 37.7406100866944 | -122.45017375512 | (37.7406100866944, -122.45017375512) | 9 | 7 | 4 | 59 | 40 | |||
80109 | 206672 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 370 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995263.98331 | 2095214.43939 | 37.732788127969 | -122.458755649049 | (37.732788127969, -122.458755649049) | 9 | 7 | 4 | 59 | 40 | |||
80368 | 51358 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 50 Pomona St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014110.4538 | 2094404.71931 | 37.7316300385939 | -122.393541499766 | (37.7316300385939, -122.393541499766) | 10 | 3 | 8 | 58 | 1 |
81319 | 206582 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 190 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993610.53275 | 2099775.23813 | 37.745215765799 | -122.464803087101 | (37.745215765799, -122.464803087101) | 1 | 8 | 4 | 29491 | 40 | |||
81352 | 206602 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Magellan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995047.85902 | 2100763.4476 | 37.7480119055303 | -122.459904663381 | (37.7480119055303, -122.459904663381) | 1 | 8 | 4 | 29491 | 40 | |||
81847 | 206567 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2523 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991381.76089 | 2098233.80223 | 37.7408546267459 | -122.472397375252 | (37.7408546267459, -122.472397375252) | 1 | 8 | 4 | 29491 | 40 | |||
83405 | 206668 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993998.36893 | 2100916.34697 | 37.7483713150869 | -122.463544824955 | (37.7483713150869, -122.463544824955) | 1 | 8 | 4 | 29491 | 40 | |||
83897 | 206503 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1957 10th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993135.46016 | 2102179.05998 | 37.7517886444405 | -122.46662048837 | (37.7517886444405, -122.46662048837) | 1 | 8 | 4 | 29491 | 12 | |||
84544 | 206550 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 308 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5994328.73662 | 2100761.78102 | 37.7479659456765 | -122.462391220472 | (37.7479659456765, -122.462391220472) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
85200 | 206628 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 20 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5994037.30563 | 2101977.91794 | 37.7512883623694 | -122.463487212563 | (37.7512883623694, -122.463487212563) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |
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 | |||
86717 | 206692 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 582 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996416.06092 | 2095880.87144 | 37.7346841407625 | -122.454820783252 | (37.7346841407625, -122.454820783252) | 9 | 7 | 4 | 59 | 40 | |||
87329 | 206675 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 300 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995199.65146 | 2095433.83543 | 37.733386838132 | -122.458993938825 | (37.733386838132, -122.458993938825) | 9 | 7 | 4 | 59 | 40 | |||
88461 | 206579 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 275 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993299.1056 | 2099684.88554 | 37.744949720257 | -122.465873376566 | (37.744949720257, -122.465873376566) | 1 | 8 | 4 | 29491 | 40 | |||
89550 | 65967 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2562 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 7 | Permit Number 28991 | 5989886.449 | 2097917.9756 | 37.7399007896882 | -122.477544471364 | (37.7399007896882, -122.477544471364) | 1 | 8 | 3 | 29491 | 35 | |
90233 | 108929 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 12x MacOndray Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008556.45633 | 2119171.57464 | 37.7993239210113 | -122.414494709684 | (37.7993239210113, -122.414494709684) | 5 | 1 | 10 | 308 | 32 | |||
92575 | 206640 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 175 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994518.44354 | 2100835.02583 | 37.7481779797266 | -122.461740536702 | (37.7481779797266, -122.461740536702) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
92777 | 247816 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 550 30th St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6003030.78831 | 2098349.34835 | 37.7418392269952 | -122.432127661269 | (37.7418392269952, -122.432127661269) | 2 | 7 | 5 | 63 | 22 | |||
95037 | 206600 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 150 Magellan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5995054.43703 | 2100813.29817 | 37.7481491609747 | -122.459885527604 | (37.7481491609747, -122.459885527604) | 1 | 8 | 4 | 29491 | 40 | |||
95861 | 200074 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1500 Van Dyke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6014921.0644 | 2093162.4986 | 37.7282641582289 | -122.39065226097 | (37.7282641582289, -122.39065226097) | 10 | 3 | 8 | 58 | 1 | |||
96906 | 206702 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998869.22619 | 2095565.73707 | 37.7339592701108 | -122.446316727449 | (37.7339592701108, -122.446316727449) | 9 | 7 | 4 | 59 | 40 | |||
97367 | 206691 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 582 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5996439.41867 | 2095873.69496 | 37.7346657757093 | -122.454739509716 | (37.7346657757093, -122.454739509716) | 9 | 7 | 4 | 59 | 40 | |||
97453 | 206694 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 125 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001630.15209 | 2095380.35715 | 37.733607556928 | -122.43675811219 | (37.733607556928, -122.43675811219) | 9 | 7 | 5 | 63 | 40 | |||
98018 | 206657 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994149.03126 | 2101531.53277 | 37.7500691388799 | -122.463068471138 | (37.7500691388799, -122.463068471138) | 1 | 8 | 4 | 29491 | 40 | |||
98988 | 206622 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1912 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993175.38418 | 2102417.55667 | 37.7524457988584 | -122.466499759777 | (37.7524457988584, -122.466499759777) | 1 | 8 | 4 | 29491 | 12 | |||
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 | |||
99436 | 47077 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 135 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | 3 | Permit Number 45064 | 5996788.5617 | 2112098.8644 | 37.7792360227866 | -122.454704245524 | (37.7792360227866, -122.454704245524) | 15 | 6 | 2 | 54 | 16 | |
101084 | 206615 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 198 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | Permit Number 779324 | 5994758.52704 | 2099346.29484 | 37.7441041156281 | -122.460802465585 | (37.7441041156281, -122.460802465585) | 1 | 8 | 4 | 59 | 40 | ||
101256 | 206522 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991046.63721 | 2100321.91518 | 37.7465686447317 | -122.473708385358 | (37.7465686447317, -122.473708385358) | 1 | 8 | 4 | 29491 | 40 | |||
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 | ||||
102548 | 206614 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 432 Dewey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995034.15561 | 2100336.79731 | 37.7468396428317 | -122.459921147044 | (37.7468396428317, -122.459921147044) | 1 | 8 | 4 | 29491 | 40 | |||
103424 | 206620 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2105 09th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993657.15968 | 2101227.85905 | 37.7492069822304 | -122.464747327347 | (37.7492069822304, -122.464747327347) | 1 | 8 | 4 | 29491 | 40 | |||
103756 | 206658 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994157.02115 | 2101539.85513 | 37.7500924502117 | -122.463041445619 | (37.7500924502117, -122.463041445619) | 1 | 8 | 4 | 29491 | 40 | |||
103846 | 223050 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 18 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001422.84544 | 2108013.2139 | 37.7682825750187 | -122.438379584463 | (37.7682825750187, -122.438379584463) | 15 | 5 | 5 | 29492 | 3 | |||
104682 | 206566 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2679 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991741.26483 | 2097200.972 | 37.7380395382962 | -122.471079130991 | (37.7380395382962, -122.471079130991) | 1 | 8 | 4 | 29491 | 40 | |||
104910 | 31750 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2546 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 5 | Permit Number 35238 | 5989885.0953 | 2098017.81 | 37.7401748305885 | -122.477556447005 | (37.7401748305885, -122.477556447005) | 1 | 8 | 3 | 29491 | 35 | |
106812 | 206577 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 215 Dorantes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5993636.26419 | 2099712.16168 | 37.7450440573323 | -122.464709533316 | (37.7450440573323, -122.464709533316) | 1 | 8 | 4 | 29491 | 40 | |||
108186 | 206701 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998876.80466 | 2095558.49789 | 37.7339398258586 | -122.446290005877 | (37.7339398258586, -122.446290005877) | 9 | 7 | 4 | 59 | 40 | |||
108499 | 218322 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 420 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5993190.15092 | 2099959.3697 | 37.7456970982494 | -122.466270063011 | (37.7456970982494, -122.466270063011) | 1 | 8 | 4 | 29491 | 40 | |||
109919 | 206599 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 150 Magellan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5995053.98462 | 2100829.4455 | 37.7481934714657 | -122.459888261529 | (37.7481934714657, -122.459888261529) | 1 | 8 | 4 | 29491 | 40 | |||
110051 | 206636 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 159 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994544.93698 | 2100878.69027 | 37.7482993963164 | -122.461652089281 | (37.7482993963164, -122.461652089281) | 1 | 8 | 4 | 29491 | 40 | |||
110106 | 63000 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1251 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1986 12:00:00 AM | 2 | Permit Number 23408 | 5983028.2339 | 2106580.2336 | 37.7632845753318 | -122.501897691969 | (37.7632845753318, -122.501897691969) | 1 | 8 | 3 | 56 | 35 | ||
110640 | 206559 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995306.63453 | 2095221.10602 | 37.7328088843117 | -122.458608676455 | (37.7328088843117, -122.458608676455) | 9 | 7 | 4 | 59 | 40 | |||
110892 | 31752 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2642 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 7 | Permit Number 35239 | 5989905.4007 | 2097381.577 | 37.7384290772799 | -122.477439751256 | (37.7384290772799, -122.477439751256) | 1 | 8 | 3 | 29491 | 35 | |
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 | |||
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 | |||
111308 | 206609 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 44 Sola Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994867.72907 | 2100768.79557 | 37.7480162285692 | -122.460527928626 | (37.7480162285692, -122.460527928626) | 1 | 8 | 4 | 29491 | 40 | |||
111783 | 206669 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994007.62455 | 2100906.4247 | 37.7483446043367 | -122.463512099503 | (37.7483446043367, -122.463512099503) | 1 | 8 | 4 | 29491 | 40 | |||
111864 | 206687 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996087.44674 | 2095957.96527 | 37.7348769661929 | -122.45596247889 | (37.7348769661929, -122.45596247889) | 9 | 7 | 4 | 59 | 40 | |||
113884 | 206558 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 517 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995506.85137 | 2100151.86426 | 37.7463590370584 | -122.458273237436 | (37.7463590370584, -122.458273237436) | 1 | 5 | 4 | 59 | 40 | |||
114209 | 206572 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993215.16949 | 2099646.04946 | 37.7448382439064 | -122.466160788211 | (37.7448382439064, -122.466160788211) | 1 | 8 | 4 | 29491 | 40 | |||
114457 | 206501 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993462.44278 | 2104571.82213 | 37.7583774159051 | -122.465663569242 | (37.7583774159051, -122.465663569242) | 1 | 8 | 4 | 56 | 12 | |||
114669 | 206502 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993453.26762 | 2104570.92091 | 37.7583744121607 | -122.465695235269 | (37.7583744121607, -122.465695235269) | 1 | 8 | 4 | 56 | 12 | |||
114722 | 218122 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Lopez Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5994032.10421 | 2100668.86964 | 37.7476937487685 | -122.463410213512 | (37.7476937487685, -122.463410213512) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
114901 | 126377 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 122 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6001345.97363 | 2121147.25207 | 37.8043408951819 | -122.439587150049 | (37.8043408951819, -122.439587150049) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
117769 | 126378 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1976 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003585.79025 | 2118315.11213 | 37.7966917978451 | -122.431633760802 | (37.7966917978451, -122.431633760802) | 13 | 9 | 1 | 57 | 17 | |||
117873 | 206667 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993986.73582 | 2100929.3593 | 37.7484063733597 | -122.463585995905 | (37.7484063733597, -122.463585995905) | 1 | 8 | 4 | 29491 | 40 | |||
117905 | 206513 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5990992.34085 | 2104483.78156 | 37.757992894562 | -122.47419976413 | (37.757992894562, -122.47419976413) | 1 | 8 | 4 | 56 | 12 | |||
118462 | 206589 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 340 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994086.71603 | 2099812.25652 | 37.7453448518007 | -122.463159224416 | (37.7453448518007, -122.463159224416) | 1 | 8 | 4 | 29491 | 40 | |||
118553 | 206677 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 228 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994904.4684 | 2095946.32835 | 37.7347770452256 | -122.460051576629 | (37.7347770452256, -122.460051576629) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
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 | |||
119747 | 38530 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2550 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1998 12:00:00 AM | 3 | Permit Number 40512 | 5986784.3655 | 2097886.9498 | 37.7396351026284 | -122.48826775932 | (37.7396351026284, -122.48826775932) | 1 | 8 | 3 | 29491 | 35 |
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) );