trees
79 rows where Neighborhoods (old) = 3 and qSpecies_id = 50 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 938 | 167297 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3500 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6004922.20627 | 2103712.53255 | 37.7566723462619 | -122.425969442941 | (37.7566723462619, -122.425969442941) | 2 | 4 | 5 | 28862 | 3 | |||
| 3860 | 106 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 927 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 6002652.29309 | 2107649.54302 | 37.7673538775163 | -122.434101048134 | (37.7673538775163, -122.434101048134) | 15 | 5 | 5 | 28862 | 3 | |||
| 5157 | 43 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 797 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6003580.94003 | 2107704.34561 | 37.7675570127652 | -122.4308929011 | (37.7675570127652, -122.4308929011) | 7 | 9 | 5 | 28862 | 3 | |||
| 7683 | 38 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 775 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6003673.2104 | 2107707.71827 | 37.7675715008638 | -122.430573990716 | (37.7675715008638, -122.430573990716) | 7 | 9 | 5 | 28862 | 3 | |||
| 8083 | 261467 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 810 14th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003376.13457 | 2107738.85817 | 37.7676401694851 | -122.431603760325 | (37.7676401694851, -122.431603760325) | 15 | 5 | 5 | 28862 | 3 | ||||
| 13157 | 253697 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 865 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003091 | 2107654 | 37.7673910038901 | -122.432583941874 | (37.7673910038901, -122.432583941874) | 15 | 5 | 5 | 28862 | 3 | ||||
| 13347 | 231129 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 821 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3x3 | 6003305.97559 | 2107686.68734 | 37.7674929441754 | -122.431842705671 | (37.7674929441754, -122.431842705671) | 15 | 5 | 5 | 28862 | 3 | |||
| 14543 | 48 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 810 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3x3 | 6003376.13457 | 2107738.85817 | 37.7676401694851 | -122.431603760325 | (37.7676401694851, -122.431603760325) | 15 | 5 | 5 | 28862 | 3 | |||
| 16192 | 50 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 811 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6003361.68382 | 2107697.25864 | 37.767525128208 | -122.431650773269 | (37.767525128208, -122.431650773269) | 15 | 5 | 5 | 28862 | 3 | |||
| 18298 | 41 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 795 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6003608.49948 | 2107706.26027 | 37.7675638314322 | -122.430797713246 | (37.7675638314322, -122.430797713246) | 7 | 9 | 5 | 28862 | 3 | |||
| 19081 | 231839 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 783 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003644.59766 | 2107707.78097 | 37.7675700520556 | -122.430672962911 | (37.7675700520556, -122.430672962911) | 7 | 9 | 5 | 28862 | 3 | |||
| 24196 | 226813 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Belcher St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003766.50306 | 2108228.71833 | 37.7690073251557 | -122.430288478441 | (37.7690073251557, -122.430288478441) | 7 | 9 | 5 | 28862 | 3 | |||
| 24719 | 226796 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 659 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002418.29753 | 2104403.09617 | 37.7584266402862 | -122.434678235738 | (37.7584266402862, -122.434678235738) | 2 | 4 | 5 | 28862 | 3 | |||
| 26859 | 226803 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4187 20th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002522.14485 | 2104118.46632 | 37.7576510101026 | -122.434298737121 | (37.7576510101026, -122.434298737121) | 2 | 4 | 5 | 28862 | 3 | |||
| 38635 | 226802 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4187 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002513.17222 | 2104117.53721 | 37.7576479497004 | -122.434329701679 | (37.7576479497004, -122.434329701679) | 2 | 4 | 5 | 28862 | 3 | |||
| 39351 | 226812 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Belcher St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 1ft | 6003760.63198 | 2108231.56549 | 37.7690148102126 | -122.430308989291 | (37.7690148102126, -122.430308989291) | 7 | 9 | 5 | 28862 | 3 | |||
| 48475 | 226811 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004456.5508 | 2107418.49179 | 37.7668217000839 | -122.427843906179 | (37.7668217000839, -122.427843906179) | 8 | 4 | 5 | 28862 | 3 | |||
| 51240 | 226804 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3520 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004856.92636 | 2103707.06921 | 37.7566536556703 | -122.42619481576 | (37.7566536556703, -122.42619481576) | 2 | 4 | 5 | 28862 | 3 | |||
| 57678 | 226799 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 701 Sanchez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6003733.12478 | 2104096.27114 | 37.7576587280713 | -122.430109091559 | (37.7576587280713, -122.430109091559) | 2 | 4 | 5 | 28862 | 3 | |||
| 58645 | 226791 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 43 Yukon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000246.5901 | 2104825.81574 | 37.7594637951501 | -122.442219288501 | (37.7594637951501, -122.442219288501) | 2 | 4 | 5 | 28862 | 3 | |||
| 59850 | 107808 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 3979 18TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003121.6 | 2105304 | 37.7609402081383 | -122.432310246363 | (37.7609402081383, -122.432310246363) | 2 | 4 | 5 | 28862 | 3 | |||
| 63895 | 226815 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4132 17th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6001471.84267 | 2105861.76416 | 37.7623780104526 | -122.438055976903 | (37.7623780104526, -122.438055976903) | 15 | 5 | 5 | 28862 | 3 | |||
| 67281 | 226817 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4430 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5999749.40261 | 2105767.64242 | 37.7620214697258 | -122.444006474335 | (37.7620214697258, -122.444006474335) | 15 | 5 | 5 | 28862 | 3 | |||
| 74231 | 226816 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4132 17th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6001458.28578 | 2105860.25499 | 37.7623730956507 | -122.438102756943 | (37.7623730956507, -122.438102756943) | 15 | 5 | 5 | 28862 | 3 | |||
| 76063 | 226809 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 85 Sharon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003890.70666 | 2106665.10208 | 37.7647210474575 | -122.429747326692 | (37.7647210474575, -122.429747326692) | 8 | 4 | 5 | 28862 | 3 | |||
| 86588 | 226807 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 48 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003212.25535 | 2107433.99017 | 37.7667937860223 | -122.432148823236 | (37.7667937860223, -122.432148823236) | 15 | 5 | 5 | 28862 | 3 | |||
| 91184 | 226792 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 379 Collingwood St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002133.75148 | 2103664.46985 | 37.7563823922541 | -122.435609479191 | (37.7563823922541, -122.435609479191) | 2 | 4 | 5 | 28862 | 3 | |||
| 97031 | 226818 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 272 Corbett Ave | 2 | Side Yard : Yard | Tree | Private 2 | 7 | Width 3ft | 5999639.14958 | 2105380.58985 | 37.7609524294432 | -122.444359978956 | (37.7609524294432, -122.444359978956) | 15 | 5 | 5 | 28862 | 3 | |||
| 99976 | 226789 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4432 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6001262.11488 | 2104680.78699 | 37.7591234062416 | -122.438696718674 | (37.7591234062416, -122.438696718674) | 2 | 4 | 5 | 28862 | 3 | |||
| 100520 | 226781 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 466 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 7x8 | 6003584.13439 | 2105555.33075 | 37.7616565176582 | -122.430728478955 | (37.7616565176582, -122.430728478955) | 15 | 4 | 5 | 28862 | 3 | |||
| 106146 | 226790 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 35 Yukon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000260.41701 | 2104714.6723 | 37.7591594105937 | -122.442163490059 | (37.7591594105937, -122.442163490059) | 2 | 4 | 5 | 28862 | 3 | |||
| 106518 | 229741 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 714 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6004954.86133 | 2104148.63623 | 37.7578716299893 | -122.425887551571 | (37.7578716299893, -122.425887551571) | 2 | 4 | 5 | 28862 | 3 | |||
| 108610 | 226808 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 26 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003130.24955 | 2108135.8166 | 37.7687161804393 | -122.432482601186 | (37.7687161804393, -122.432482601186) | 15 | 5 | 5 | 28862 | 3 | |||
| 109397 | 226787 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 166 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002663.06838 | 2104932.43611 | 37.7598939732341 | -122.43386954555 | (37.7598939732341, -122.43386954555) | 2 | 4 | 5 | 28862 | 3 | |||
| 112490 | 226778 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3934 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003366.66584 | 2105380.90028 | 37.761165250397 | -122.431468161443 | (37.761165250397, -122.431468161443) | 15 | 4 | 5 | 28862 | 3 | |||
| 124976 | 226779 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3974 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003146.24554 | 2105369.35546 | 37.76112105592 | -122.432229675877 | (37.76112105592, -122.432229675877) | 15 | 4 | 5 | 28862 | 3 | |||
| 129006 | 226794 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 267 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001783.4277 | 2104311.13216 | 37.7581380667326 | -122.4368673106 | (37.7581380667326, -122.4368673106) | 2 | 4 | 5 | 28862 | 3 | |||
| 130979 | 226810 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 85 Sharon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003888.71107 | 2106689.12082 | 37.7647868841307 | -122.429755942181 | (37.7647868841307, -122.429755942181) | 8 | 4 | 5 | 28862 | 3 | |||
| 131236 | 226814 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 63 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003182.02121 | 2107933.96626 | 37.7681648843321 | -122.432289109354 | (37.7681648843321, -122.432289109354) | 15 | 5 | 5 | 28862 | 3 | |||
| 138763 | 226797 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3970 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003894.50507 | 2104240.41525 | 37.7580636523416 | -122.429561252457 | (37.7580636523416, -122.429561252457) | 2 | 4 | 5 | 28862 | 3 | |||
| 140532 | 226793 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 379 Collingwood St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002133.14773 | 2103676.31571 | 37.7564148838461 | -122.435612414605 | (37.7564148838461, -122.435612414605) | 2 | 4 | 5 | 28862 | 3 | |||
| 153023 | 226782 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 579 Noe St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6003036.36439 | 2104869.3742 | 37.7597419968272 | -122.432573993 | (37.7597419968272, -122.432573993) | 2 | 4 | 5 | 28862 | 3 | |||
| 153755 | 226788 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 133 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002056.46904 | 2105062.33058 | 37.7602161904576 | -122.43597676864 | (37.7602161904576, -122.43597676864) | 2 | 4 | 5 | 28862 | 3 | |||
| 155526 | 226784 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 549 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003023.04842 | 2105091.71244 | 37.7603517290589 | -122.432635928409 | (37.7603517290589, -122.432635928409) | 2 | 4 | 5 | 28862 | 3 | |||
| 156001 | 226798 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3992 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003742.96223 | 2104233.19003 | 37.7580352319537 | -122.430084836864 | (37.7580352319537, -122.430084836864) | 2 | 4 | 5 | 28862 | 3 | |||
| 157854 | 226806 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 190 Storrie St | 8 | Front Yard : Yard | Tree | Private 2 | 3 | Width 3ft | 6000773.9022 | 2105295.69732 | 37.7607840134024 | -122.440429287805 | (37.7607840134024, -122.440429287805) | 15 | 4 | 5 | 28862 | 3 | |||
| 162653 | 251225 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1 Yukon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x2.5 | 6000238 | 2104757 | 37.7592743544717 | -122.442244057145 | (37.7592743544717, -122.442244057145) | 2 | 4 | 5 | 28862 | 3 | ||||
| 163736 | 226783 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 579 Noe St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003034.17518 | 2104887.2525 | 37.7597909621971 | -122.432582841439 | (37.7597909621971, -122.432582841439) | 2 | 4 | 5 | 28862 | 3 | |||
| 169196 | 226795 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 677 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002427.79388 | 2104301.04841 | 37.7581469808114 | -122.434638096272 | (37.7581469808114, -122.434638096272) | 2 | 4 | 5 | 28862 | 3 | |||
| 181243 | 226780 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3980 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003123.97049 | 2105369.10011 | 37.7611190917893 | -122.432306697403 | (37.7611190917893, -122.432306697403) | 15 | 4 | 5 | 28862 | 3 | |||
| 184418 | 226786 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3894 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003740.86919 | 2104813.89584 | 37.7596295932412 | -122.430133501864 | (37.7596295932412, -122.430133501864) | 2 | 4 | 5 | 28862 | 3 | |||
| 186292 | 226801 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 545 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002785.55177 | 2103842.18407 | 37.7569073526207 | -122.433368026935 | (37.7569073526207, -122.433368026935) | 2 | 4 | 5 | 28862 | 3 | |||
| 186551 | 226785 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3894 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003780.43348 | 2104817.05272 | 37.7596405020293 | -122.429996893968 | (37.7596405020293, -122.429996893968) | 2 | 4 | 5 | 28862 | 3 | |||
| 109741 | 39737 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3892 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41105 | 6003712.19802155 | 2104818.42047752 | 37.759640392907 | -122.430232983891 | (37.759640392907, -122.430232983891) | 2 | 4 | 5 | 28862 | 3 | ||
| 130336 | 39735 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3892 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41105 | 6003712.19802155 | 2104818.42047752 | 37.759640392907 | -122.430232983891 | (37.759640392907, -122.430232983891) | 2 | 4 | 5 | 28862 | 3 | ||
| 152582 | 41339 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 791 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2000 12:00:00 AM | 8 | Permit Number 41992 | 6002462.02491535 | 2103606.38445454 | 37.7562415435961 | -122.434470043403 | (37.7562415435961, -122.434470043403) | 2 | 4 | 5 | 28862 | 3 | ||
| 11638 | 95638 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767404 | 6004462 | 2107407 | 37.7667904546556 | -122.427824239372 | (37.7667904546556, -122.427824239372) | 8 | 4 | 5 | 28862 | 3 | |
| 145866 | 91415 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 46 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2009 12:00:00 AM | 3x3 | Permit Number 52098 | 6003215 | 2107427 | 37.7667747483278 | -122.432138830712 | (37.7667747483278, -122.432138830712) | 15 | 5 | 5 | 28862 | 3 | ||
| 6567 | 45 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 810 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/05/1990 12:00:00 AM | 12 | 3x3 | 6003436.52432 | 2107742.06145 | 37.7676523876611 | -122.431395108624 | (37.7676523876611, -122.431395108624) | 15 | 5 | 5 | 28862 | 3 | ||
| 82797 | 37263 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3520 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39807 | 6004880.29315542 | 2103713.53429444 | 37.7566727279873 | -122.426114465107 | (37.7566727279873, -122.426114465107) | 2 | 4 | 5 | 28862 | 3 | ||
| 50547 | 55554 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 159 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50800 | 6000262.70357659 | 2104857.37596764 | 37.7595513701063 | -122.44216582584 | (37.7595513701063, -122.44216582584) | 2 | 4 | 5 | 28862 | 3 | ||
| 2827 | 253039 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 531 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2017 12:00:00 AM | 3 | 13x6.5 | 6003687 | 2105184 | 37.7606427596565 | -122.43034621439 | (37.7606427596565, -122.43034621439) | 2 | 4 | 5 | 28862 | 3 | ||
| 56787 | 83340 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4201 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52615 | 6002013.46643782 | 2105257.92812677 | 37.7607508108309 | -122.436139491461 | (37.7607508108309, -122.436139491461) | 2 | 4 | 5 | 28862 | 3 | |
| 185655 | 74908 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4201 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52615 | 6002013.46643782 | 2105257.92812677 | 37.7607508108309 | -122.436139491461 | (37.7607508108309, -122.436139491461) | 2 | 4 | 5 | 28862 | 3 | |
| 72482 | 64228 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 24 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2012 12:00:00 AM | Permit Number 769264 | 6003122.11049357 | 2108174.45220479 | 37.7688218028269 | -122.43251351352 | (37.7688218028269, -122.43251351352) | 15 | 5 | 5 | 28862 | 3 | |||
| 6402 | 94573 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3978 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53752 | 6003116 | 2105363 | 37.761101890414 | -122.432333828196 | (37.761101890414, -122.432333828196) | 15 | 4 | 5 | 28862 | 3 | ||
| 58895 | 94579 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 615 Noe St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53757 | 6003043 | 2104661 | 37.7591702275755 | -122.432536159886 | (37.7591702275755, -122.432536159886) | 2 | 4 | 5 | 28862 | 3 | ||
| 104313 | 226800 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 611 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/2010 12:00:00 AM | 3 | Width 3ft | Permit Number 53757 | 6003049.61247 | 2104666.39775 | 37.7591854234811 | -122.432513676359 | (37.7591854234811, -122.432513676359) | 2 | 4 | 5 | 28862 | 3 | |
| 183347 | 68748 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3974 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53751 | 6003148.31037661 | 2105371.6272327 | 37.7611274107355 | -122.432222696746 | (37.7611274107355, -122.432222696746) | 15 | 4 | 5 | 28862 | 3 | |
| 136750 | 59221 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2009 12:00:00 AM | 3x3 | Permit Number 52989 | 6004451.77295889 | 2107409.78146369 | 37.7667975133385 | -122.427859811231 | (37.7667975133385, -122.427859811231) | 8 | 4 | 5 | 28862 | 3 | |
| 761 | 224987 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 484 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782366 | 6003591.74199 | 2105457.02251 | 37.7613870178149 | -122.430695151865 | (37.7613870178149, -122.430695151865) | 15 | 4 | 5 | 28862 | 3 | |
| 4536 | 224986 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 484 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782366 | 6003589.47712 | 2105476.68017 | 37.7614408647212 | -122.430704387917 | (37.7614408647212, -122.430704387917) | 15 | 4 | 5 | 28862 | 3 | |
| 118063 | 68774 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 559 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32703 | 6003671.21705714 | 2105010.40354042 | 37.7601652112687 | -122.430388414345 | (37.7601652112687, -122.430388414345) | 2 | 4 | 5 | 28862 | 3 | ||
| 1985 | 47 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 810 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/03/1998 12:00:00 AM | 6 | 3x3 | 6003389.55254 | 2107739.47109 | 37.7676426129451 | -122.431557393053 | (37.7676426129451, -122.431557393053) | 15 | 5 | 5 | 28862 | 3 | ||
| 159303 | 45811 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 71 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2001 12:00:00 AM | Permit Number 44439 | 6000723.05882095 | 2104884.41992047 | 37.7596518513768 | -122.440575632448 | (37.7596518513768, -122.440575632448) | 2 | 4 | 5 | 28862 | 3 | |||
| 94618 | 84806 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 545 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53985 | 6002776 | 2103844 | 37.7569117968289 | -122.433401190257 | (37.7569117968289, -122.433401190257) | 2 | 4 | 5 | 28862 | 3 | |
| 3571 | 102167 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 677 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769761 | 6002448.6 | 2104297.1 | 37.7581373205651 | -122.4345658575 | (37.7581373205651, -122.4345658575) | 2 | 4 | 5 | 28862 | 3 |
| 93994 | 102177 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 267 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 5 | 6x9 | Permit Number 769769 | 6001804.7 | 2104316.3 | 37.758153465364 | -122.436794111878 | (37.758153465364, -122.436794111878) | 2 | 4 | 5 | 28862 | 3 |
| 162120 | 58905 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 655 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | Permit Number 769760 | 6002418.15212939 | 2104399.4018004 | 37.7584164881822 | -122.434678474426 | (37.7584164881822, -122.434678474426) | 2 | 4 | 5 | 28862 | 3 |
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) );