trees
98 rows where qSpecies_id = 293
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5668 | 36766 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 2500X Jennings St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39524 | 6014687.8788 | 2091681.7425 | 37.7241853583552 | -122.391354929146 | (37.7241853583552, -122.391354929146) | 10 | 3 | 8 | 58 | 1 |
| 5900 | 14792 | Permitted Site 7 | Rhaphiolepis indica :: India Hawthorn 293 | 1077 McAllister St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1997 12:00:00 AM | 6 | 4X4 | 6004038.31085 | 2111808.31104 | 37.7788514015092 | -122.429603641013 | (37.7788514015092, -122.429603641013) | 7 | 9 | 11 | 29490 | 41 | ||
| 8351 | 261505 | Undocumented 4 | Rhaphiolepis indica :: India Hawthorn 293 | 50 Lunado Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5991584 | 2091622 | 37.7227119804791 | -122.471216515117 | (37.7227119804791, -122.471216515117) | 9 | 8 | 4 | 59 | 40 | ||||
| 9443 | 224041 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 3900 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004443.2007 | 2101347.07782 | 37.7501502784152 | -122.427457508869 | (37.7501502784152, -122.427457508869) | 2 | 4 | 5 | 28862 | 22 | |||
| 9766 | 14759 | Permitted Site 7 | Rhaphiolepis indica :: India Hawthorn 293 | 963 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1997 12:00:00 AM | 6 | 4X4 | 6004543.30583 | 2111878.13502 | 37.7790717017782 | -122.42786163982 | (37.7790717017782, -122.42786163982) | 7 | 9 | 11 | 29490 | 41 | ||
| 11052 | 142951 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 260 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6010600.7711 | 2121024.4709 | 37.8045261528823 | -122.407551341514 | (37.8045261528823, -122.407551341514) | 3 | 1 | 10 | 308 | 23 | |||
| 18858 | 261506 | Undocumented 4 | Rhaphiolepis indica :: India Hawthorn 293 | 50 Lunado Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5991584 | 2091622 | 37.7227119804791 | -122.471216515117 | (37.7227119804791, -122.471216515117) | 9 | 8 | 4 | 59 | 40 | ||||
| 20027 | 142952 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 260 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6010578.8148 | 2121025.3492 | 37.8045273354567 | -122.407627385624 | (37.8045273354567, -122.407627385624) | 3 | 1 | 10 | 308 | 23 | |||
| 22842 | 100546 | Undocumented 4 | Rhaphiolepis indica :: India Hawthorn 293 | 95 Eagle St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5999799.7 | 2104413.1 | 37.7583051000651 | -122.443735199357 | (37.7583051000651, -122.443735199357) | 2 | 4 | 5 | 28862 | 3 | |||
| 24161 | 141635 | Undocumented 4 | Rhaphiolepis indica :: India Hawthorn 293 | 1801 GROVE ST | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999100.4781 | 2110425.5241 | 37.7747737968525 | -122.446585977454 | (37.7747737968525, -122.446585977454) | 15 | 5 | 11 | 29492 | 16 | |||
| 24817 | 173696 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 300X Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011493 | 2112899 | 37.7822654576831 | -122.403891551821 | (37.7822654576831, -122.403891551821) | 6 | 2 | 9 | 28853 | 34 | ||||
| 25312 | 142703 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 540 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6008703.7216 | 2121109.6414 | 37.8046536403427 | -122.414122306002 | (37.8046536403427, -122.414122306002) | 3 | 1 | 10 | 308 | 23 | |||
| 26660 | 96258 | Permitted Site 7 | Rhaphiolepis indica :: India Hawthorn 293 | 192@ Congdon Ney St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004645 | 2094034 | 37.7300816406458 | -122.42623908205 | (37.7300816406458, -122.42623908205) | 9 | 7 | 6 | 28861 | 5 | ||||
| 27409 | 199826 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1425 Bancroft Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015123.6671 | 2091538.6638 | 37.7238166693011 | -122.389838471515 | (37.7238166693011, -122.389838471515) | 10 | 3 | 8 | 58 | 1 | |||
| 28020 | 199827 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1425 Bancroft Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015144.6475 | 2091520.3906 | 37.7237676581721 | -122.389764669402 | (37.7237676581721, -122.389764669402) | 10 | 3 | 8 | 58 | 1 | |||
| 28288 | 142329 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 402 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000217.4342 | 2110323.0671 | 37.7745562133453 | -122.442714849938 | (37.7745562133453, -122.442714849938) | 15 | 5 | 11 | 29492 | 16 | |||
| 31154 | 14758 | Permitted Site 7 | Rhaphiolepis indica :: India Hawthorn 293 | 959 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/1997 12:00:00 AM | 6 | 4X4 | 6004560.34037 | 2111885.53819 | 37.7790929927003 | -122.427803238057 | (37.7790929927003, -122.427803238057) | 7 | 9 | 11 | 29490 | 41 | ||
| 31973 | 182024 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1405 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5988955.628 | 2105738.0832 | 37.761318669937 | -122.481335351833 | (37.761318669937, -122.481335351833) | 1 | 8 | 3 | 56 | 35 | |||
| 32567 | 14768 | Permitted Site 7 | Rhaphiolepis indica :: India Hawthorn 293 | 1000X McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 11/25/1992 12:00:00 AM | 3 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | ||
| 34987 | 200806 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1131 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015028.9943 | 2090215.3382 | 37.7201778277868 | -122.39007334075 | (37.7201778277868, -122.39007334075) | 10 | 3 | 8 | 58 | 1 | |||
| 35333 | 100547 | Undocumented 4 | Rhaphiolepis indica :: India Hawthorn 293 | 95 Eagle St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5999799.7 | 2104413.1 | 37.7583051000651 | -122.443735199357 | (37.7583051000651, -122.443735199357) | 2 | 4 | 5 | 28862 | 3 | |||
| 37045 | 141907 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 900 MCALLISTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004649.797 | 2111940.7357 | 37.7792496115336 | -122.427497704497 | (37.7792496115336, -122.427497704497) | 7 | 9 | 11 | 29490 | 41 | |||
| 38089 | 36779 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1420 Carroll Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 4 | Permit Number 39525 | 6014930.9335 | 2091408.5126 | 37.7234486098528 | -122.390495635348 | (37.7234486098528, -122.390495635348) | 10 | 3 | 8 | 58 | 1 | |
| 38825 | 1891 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 63 Beatrice Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/25/1998 12:00:00 AM | 3 | 3X4 | 6017750.3499232 | 2094174.2048031 | 37.7311986673034 | -122.380941507869 | (37.7311986673034, -122.380941507869) | 10 | 3 | 8 | 58 | 1 | ||
| 40043 | 199824 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1425 Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015081.7063 | 2091571.1496 | 37.7239035418161 | -122.389985792512 | (37.7239035418161, -122.389985792512) | 10 | 3 | 8 | 58 | 1 | |||
| 42374 | 36771 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1501 Bancroft Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 4 | Permit Number 39524 | 6014699.3216 | 2091860.1377 | 37.7246758311156 | -122.391327837604 | (37.7246758311156, -122.391327837604) | 10 | 3 | 8 | 58 | 1 | |
| 45059 | 199658 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1329 Egbert Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6014600.2068 | 2090881.6643 | 37.7219836364279 | -122.391602089471 | (37.7219836364279, -122.391602089471) | 10 | 3 | 8 | 58 | 1 | |||
| 48016 | 36153 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 51 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1998 12:00:00 AM | 8 | Permit Number 39237 | 5996490.2429 | 2114232.4446 | 37.7850771527555 | -122.455890527593 | (37.7850771527555, -122.455890527593) | 11 | 6 | 1 | 54 | 31 | |
| 48129 | 141627 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1801 GROVE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998972.9815 | 2110407.3536 | 37.7747166218573 | -122.44702570477 | (37.7747166218573, -122.44702570477) | 15 | 5 | 11 | 29492 | 16 | |||
| 48791 | 223594 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 376 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6007794.5106 | 2105672.41812 | 37.7622156522408 | -122.416174744881 | (37.7622156522408, -122.416174744881) | 8 | 4 | 7 | 28859 | 19 | |||
| 51431 | 200807 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1520 Carroll Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6014526.5089 | 2091713.0492 | 37.7242623629261 | -122.391914953581 | (37.7242623629261, -122.391914953581) | 10 | 3 | 8 | 58 | 1 | |||
| 54246 | 182597 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 2745 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5985426.5834 | 2102255.7383 | 37.7515513017834 | -122.493284094849 | (37.7515513017834, -122.493284094849) | 1 | 8 | 3 | 29491 | 35 | |||
| 54928 | 244867 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1295 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000406.6839 | 2109217.809 | 37.7715322400702 | -122.441980851682 | (37.7715322400702, -122.441980851682) | 15 | 5 | 11 | 29492 | 9 | |||
| 57463 | 182542 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1400 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5987757.1459 | 2105672.8056 | 37.7610696830266 | -122.485475554287 | (37.7610696830266, -122.485475554287) | 1 | 8 | 3 | 56 | 35 | |||
| 60922 | 200841 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1919 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6010660.9887 | 2106915.0801 | 37.7657884803505 | -122.406348196098 | (37.7657884803505, -122.406348196098) | 8 | 4 | 8 | 28853 | 19 | |||
| 62104 | 36770 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1501 Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 4 | Permit Number 39524 | 6014642.4715 | 2091903.452 | 37.7247916082347 | -122.391527389659 | (37.7247916082347, -122.391527389659) | 10 | 3 | 8 | 58 | 1 | |
| 63524 | 181673 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 2750 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5987138.3252 | 2106450.2218 | 37.7631681813025 | -122.48767287412 | (37.7631681813025, -122.48767287412) | 1 | 8 | 3 | 56 | 35 | |||
| 63858 | 121668 | Undocumented 4 | Rhaphiolepis indica :: India Hawthorn 293 | 92X Fairfield Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993836 | 2093526 | 37.7280699074048 | -122.463570014172 | (37.7280699074048, -122.463570014172) | 9 | 8 | 4 | 59 | 40 | ||||
| 64964 | 141926 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1050 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004287.7311 | 2111890.8123 | 37.7790920490766 | -122.428746680554 | (37.7790920490766, -122.428746680554) | 7 | 9 | 11 | 29490 | 41 | |||
| 67405 | 36767 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 2500X Jennings St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39524 | 6014678.4219 | 2091667.2791 | 37.7241451198738 | -122.391386609894 | (37.7241451198738, -122.391386609894) | 10 | 3 | 8 | 58 | 1 |
| 67415 | 186322 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1800 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984988.115 | 2102882.2529 | 37.7532458825913 | -122.49484653936 | (37.7532458825913, -122.49484653936) | 1 | 8 | 3 | 56 | 35 | |||
| 67606 | 185751 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 2040 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986780.1586 | 2100318.0978 | 37.7463101414778 | -122.488460933983 | (37.7463101414778, -122.488460933983) | 1 | 8 | 3 | 29491 | 35 | |||
| 68450 | 182543 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1400 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5987755.4825 | 2105692.7662 | 37.7611243924676 | -122.485482772032 | (37.7611243924676, -122.485482772032) | 1 | 8 | 3 | 56 | 35 | |||
| 70922 | 181795 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1823 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5987210.5478 | 2099595.8709 | 37.7443522025088 | -122.486919689316 | (37.7443522025088, -122.486919689316) | 1 | 8 | 3 | 29491 | 35 | |||
| 72498 | 42665 | Permitted Site 7 | Rhaphiolepis indica :: India Hawthorn 293 | 784 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2011 12:00:00 AM | Permit Number 768090 | 6007030.40874705 | 2121231.86191907 | 37.8048950989502 | -122.419921658381 | (37.8048950989502, -122.419921658381) | 5 | 1 | 1 | 28858 | 32 | |||
| 78530 | 36810 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1315 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 6 | Permit Number 39533 | 6014687.9133 | 2090815.2753 | 37.7218062133576 | -122.391294269094 | (37.7218062133576, -122.391294269094) | 10 | 3 | 8 | 58 | 1 | |
| 83557 | 1897 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 95 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/25/1998 12:00:00 AM | 3 | 3X4 | 6017638.1071524 | 2094354.0127634 | 37.7316861888132 | -122.381342053504 | (37.7316861888132, -122.381342053504) | 10 | 3 | 8 | 58 | 1 | ||
| 85194 | 100418 | Undocumented 4 | Rhaphiolepis indica :: India Hawthorn 293 | 1658 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999871 | 2110573 | 37.7752227103974 | -122.443931190755 | (37.7752227103974, -122.443931190755) | 15 | 5 | 11 | 29492 | 16 | |||||
| 85973 | 36768 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 2500X Jennings St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39524 | 6014665.3843 | 2091652.3818 | 37.7241034912437 | -122.391430638324 | (37.7241034912437, -122.391430638324) | 10 | 3 | 8 | 58 | 1 |
| 89646 | 181683 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1323 32nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5986143.3846 | 2106221.2354 | 37.762481367295 | -122.491097140345 | (37.762481367295, -122.491097140345) | 1 | 8 | 3 | 56 | 35 | |||
| 90640 | 244476 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 178 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005704.103 | 2110167.9913 | 37.7744416615498 | -122.423724339103 | (37.7744416615498, -122.423724339103) | 7 | 9 | 11 | 28852 | 10 | |||
| 94653 | 183764 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 2287 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986983.1004 | 2099694.706 | 37.7446103136293 | -122.487713403903 | (37.7446103136293, -122.487713403903) | 1 | 8 | 3 | 29491 | 35 | |||
| 96856 | 140928 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 184 COLLINS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998138.9493 | 2113314.2217 | 37.7826504401233 | -122.450120342134 | (37.7826504401233, -122.450120342134) | 15 | 6 | 1 | 54 | 31 | |||
| 100616 | 199825 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1425 Bancroft Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015102.6867 | 2091554.2299 | 37.723858247223 | -122.389912084717 | (37.723858247223, -122.389912084717) | 10 | 3 | 8 | 58 | 1 | |||
| 100666 | 182598 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 2741 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5985445.2901 | 2102255.7383 | 37.7515523959304 | -122.49321940568 | (37.7515523959304, -122.49321940568) | 1 | 8 | 3 | 29491 | 35 | |||
| 105302 | 141985 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1067 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004082.1666 | 2111810.3934 | 37.7788596022529 | -122.429452075182 | (37.7788596022529, -122.429452075182) | 7 | 9 | 11 | 29490 | 41 | |||
| 110803 | 36776 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1502X Carroll Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39524 | 6014605.0793 | 2091650.3147 | 37.7240944681401 | -122.391638960766 | (37.7240944681401, -122.391638960766) | 10 | 3 | 8 | 58 | 1 |
| 110845 | 36772 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1501 Bancroft Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 4 | Permit Number 39524 | 6014747.3735 | 2091825.6215 | 37.7245837232397 | -122.391159315335 | (37.7245837232397, -122.391159315335) | 10 | 3 | 8 | 58 | 1 | |
| 111306 | 184500 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1886 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983838.0054 | 2102333.8724 | 37.7516727915847 | -122.498783281153 | (37.7516727915847, -122.498783281153) | 1 | 8 | 3 | 56 | 35 | |||
| 111711 | 121670 | Undocumented 4 | Rhaphiolepis indica :: India Hawthorn 293 | 92X Fairfield Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993836 | 2093526 | 37.7280699074048 | -122.463570014172 | (37.7280699074048, -122.463570014172) | 9 | 8 | 4 | 59 | 40 | ||||
| 112045 | 200718 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1501 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015503.4948 | 2095103.8844 | 37.7336271100907 | -122.388774230409 | (37.7336271100907, -122.388774230409) | 10 | 3 | 8 | 58 | 1 | |||
| 112777 | 244064 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1672 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998579.8831 | 2109008.0253 | 37.7708519577518 | -122.448284719618 | (37.7708519577518, -122.448284719618) | 15 | 5 | 11 | 29492 | 9 | |||
| 114678 | 36769 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1501 Bancroft Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39524 | 6014724.3628 | 2091841.1876 | 37.7246251876562 | -122.39123994858 | (37.7246251876562, -122.39123994858) | 10 | 3 | 8 | 58 | 1 |
| 115117 | 185752 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 2050 Rivera St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986758.4712 | 2100317.5556 | 37.7463073872785 | -122.488535885582 | (37.7463073872785, -122.488535885582) | 1 | 8 | 3 | 29491 | 35 | |||
| 115446 | 100544 | Undocumented 4 | Rhaphiolepis indica :: India Hawthorn 293 | 95 Eagle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6000135 | 2104379 | 37.7582305885461 | -122.442573139957 | (37.7582305885461, -122.442573139957) | 2 | 4 | 5 | 28862 | 3 | |||
| 117287 | 141953 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 963 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004639.1551 | 2111883.5503 | 37.7790919926055 | -122.427530444095 | (37.7790919926055, -122.427530444095) | 7 | 9 | 11 | 29490 | 41 | |||
| 117474 | 181798 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1817 Santiago St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5987268.7564 | 2099598.5782 | 37.7443630296489 | -122.48671861758 | (37.7443630296489, -122.48671861758) | 1 | 8 | 3 | 29491 | 35 | |||
| 118350 | 14748 | Permitted Site 7 | Rhaphiolepis indica :: India Hawthorn 293 | 930 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2001 12:00:00 AM | 3 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | ||
| 122009 | 141905 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 900 MCALLISTER ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004708.2025 | 2111950.1873 | 37.7792788665473 | -122.42729632907 | (37.7792788665473, -122.42729632907) | 7 | 9 | 11 | 29490 | 41 | |||
| 124194 | 183765 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 2289 30th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986984.3806 | 2099675.5028 | 37.7445576614381 | -122.487707566764 | (37.7445576614381, -122.487707566764) | 1 | 8 | 3 | 29491 | 35 | |||
| 132814 | 181672 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 2748 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5987165.4903 | 2106450.8124 | 37.7631713873156 | -122.487578963751 | (37.7631713873156, -122.487578963751) | 1 | 8 | 3 | 56 | 35 | |||
| 136094 | 141625 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1801 GROVE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998942.3945 | 2110403.1138 | 37.7747032328749 | -122.447131205797 | (37.7747032328749, -122.447131205797) | 15 | 5 | 11 | 29492 | 16 | |||
| 137068 | 42667 | Permitted Site 7 | Rhaphiolepis indica :: India Hawthorn 293 | 784 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2011 12:00:00 AM | Permit Number 768090 | 6007030.40874705 | 2121231.86191907 | 37.8048950989502 | -122.419921658381 | (37.8048950989502, -122.419921658381) | 5 | 1 | 1 | 28858 | 32 | |||
| 142505 | 100548 | Undocumented 4 | Rhaphiolepis indica :: India Hawthorn 293 | 95 Eagle St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5999799.7 | 2104413.1 | 37.7583051000651 | -122.443735199357 | (37.7583051000651, -122.443735199357) | 2 | 4 | 5 | 28862 | 3 | |||
| 146140 | 137783 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 2152 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999208.8325 | 2111528.684 | 37.7778089797104 | -122.446290532484 | (37.7778089797104, -122.446290532484) | 15 | 5 | 11 | 54 | 16 | |||
| 147909 | 36817 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1315 Egbert Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 5 | Permit Number 39533 | 6014719.5851 | 2090790.9124 | 37.7217410753408 | -122.391183084885 | (37.7217410753408, -122.391183084885) | 10 | 3 | 8 | 58 | 1 | |
| 148560 | 36759 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 2500X Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39524 | 6014769.3721 | 2091785.0559 | 37.7244735589534 | -122.391080434358 | (37.7244735589534, -122.391080434358) | 10 | 3 | 8 | 58 | 1 |
| 152278 | 14746 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 920 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/19/1997 12:00:00 AM | 6 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | ||
| 158688 | 100545 | Undocumented 4 | Rhaphiolepis indica :: India Hawthorn 293 | 95 Eagle St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5999799.7 | 2104413.1 | 37.7583051000651 | -122.443735199357 | (37.7583051000651, -122.443735199357) | 2 | 4 | 5 | 28862 | 3 | |||
| 163094 | 141634 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1801 GROVE ST | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999084.7303 | 2110422.4957 | 37.774764582111 | -122.446640234184 | (37.774764582111, -122.446640234184) | 15 | 5 | 11 | 29492 | 16 | |||
| 165538 | 119908 | Undocumented 4 | Rhaphiolepis indica :: India Hawthorn 293 | 2x Lucy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014137 | 2094073 | 37.7307206798387 | -122.393426517634 | (37.7307206798387, -122.393426517634) | 10 | 3 | 8 | 58 | 1 | ||||
| 167424 | 36774 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1500X Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39524 | 6014623.9606 | 2091637.5241 | 37.7240603957553 | -122.391572796643 | (37.7240603957553, -122.391572796643) | 10 | 3 | 8 | 58 | 1 |
| 167680 | 36778 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1501 Bancroft Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 4 | Permit Number 39524 | 6014675.6341 | 2091877.0573 | 37.7247209742938 | -122.391410905253 | (37.7247209742938, -122.391410905253) | 10 | 3 | 8 | 58 | 1 | |
| 167827 | 140245 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 120 Ashbury St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998764.3233 | 2110283.6425 | 37.774365019404 | -122.447738585062 | (37.774365019404, -122.447738585062) | 15 | 5 | 11 | 29492 | 16 | |||
| 168929 | 9344 | Permitted Site 7 | Rhaphiolepis indica :: India Hawthorn 293 | 213 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 2X2 | 6000786.4388958 | 2098493.5307894 | 37.7421076160586 | -122.439898203654 | (37.7421076160586, -122.439898203654) | 2 | 7 | 5 | 63 | 7 | |||
| 169731 | 186321 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1800 Sunset Blvd | 59 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984997.3777 | 2102873.7956 | 37.7532232033747 | -122.494813884029 | (37.7532232033747, -122.494813884029) | 1 | 8 | 3 | 56 | 35 | |||
| 174178 | 184175 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1661 31st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986535.3214 | 2103935.1312 | 37.7562272455536 | -122.489573475318 | (37.7562272455536, -122.489573475318) | 1 | 8 | 3 | 56 | 35 | |||
| 175272 | 197357 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1199 Indiana St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6015070.81773 | 2103040.163 | 37.7553944914738 | -122.390824580408 | (37.7553944914738, -122.390824580408) | 10 | 3 | 8 | 28856 | 29 | |||
| 176984 | 140243 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 140 Ashbury St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998770.6829 | 2110240.9418 | 37.774248137702 | -122.447713511512 | (37.774248137702, -122.447713511512) | 15 | 5 | 11 | 29492 | 16 | |||
| 180302 | 141257 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 51 COMMONWEALTH AVE | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5996492.2734 | 2114210.7856 | 37.7850177994523 | -122.455881936455 | (37.7850177994523, -122.455881936455) | 11 | 6 | 1 | 54 | 31 | |||
| 183451 | 36787 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1420 Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 3 | Permit Number 39525 | 6014949.8148 | 2091395.7221 | 37.723414537097 | -122.39042947233 | (37.723414537097, -122.39042947233) | 10 | 3 | 8 | 58 | 1 | |
| 183633 | 223595 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 376 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007793.65199 | 2105696.06013 | 37.762280519451 | -122.416179388972 | (37.762280519451, -122.416179388972) | 8 | 4 | 7 | 28859 | 19 | |||
| 183676 | 181671 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 2746 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5987187.9311 | 2106452.584 | 37.763177560431 | -122.487501479694 | (37.763177560431, -122.487501479694) | 1 | 8 | 3 | 56 | 35 | |||
| 185498 | 183763 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 2285 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986982.2469 | 2099714.336 | 37.7446641625869 | -122.487717796975 | (37.7446641625869, -122.487717796975) | 1 | 8 | 3 | 29491 | 35 | |||
| 189380 | 137785 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 2170 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999151.477 | 2111523.1335 | 37.7777904636399 | -122.446488544871 | (37.7777904636399, -122.446488544871) | 15 | 5 | 11 | 54 | 16 | |||
| 189593 | 141952 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 963 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004611.6165 | 2111879.6949 | 37.779079848976 | -122.427625436585 | (37.779079848976, -122.427625436585) | 7 | 9 | 11 | 29490 | 41 | |||
| 193728 | 173695 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 300X Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011493 | 2112899 | 37.7822654576831 | -122.403891551821 | (37.7822654576831, -122.403891551821) | 6 | 2 | 9 | 28853 | 34 | ||||
| 193800 | 199654 | DPW Maintained 1 | Rhaphiolepis indica :: India Hawthorn 293 | 1329 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6014555.7444 | 2090915.7724 | 37.7220748224088 | -122.391758169756 | (37.7220748224088, -122.391758169756) | 10 | 3 | 8 | 58 | 1 |
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) );