trees
272 rows where Supervisor Districts = 5 and qSpecies_id = 50 sorted by YCoord descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 155463 | 36721 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 31 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39505 | 6005645.10091643 | 2108871.29821034 | 37.7708779241001 | -122.423836216701 | (37.7708779241001, -122.423836216701) | 8 | 2 | 5 | 28853 | 19 | ||
| 187304 | 228524 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 29 Pearl St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6005636.60822 | 2108865.67188 | 37.7708619961085 | -122.42386519304 | (37.7708619961085, -122.42386519304) | 8 | 2 | 5 | 28853 | 19 | |||
| 157868 | 226819 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 70 Potomac St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003113.42277 | 2108740.53818 | 37.7703756436569 | -122.432584004272 | (37.7703756436569, -122.432584004272) | 15 | 5 | 5 | 29492 | 9 | |||
| 78982 | 50683 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 114 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | Permit Number 47255 | 6001960.98018226 | 2108347.90798031 | 37.7692321564841 | -122.436542190439 | (37.7692321564841, -122.436542190439) | 15 | 5 | 5 | 29492 | 9 | |||
| 55010 | 247662 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 108 Divisadero St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6001959.68947 | 2108344.83823 | 37.7692236543626 | -122.436546435187 | (37.7692236543626, -122.436546435187) | 15 | 5 | 5 | 29492 | 9 | |||
| 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 | |||
| 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 | |||
| 134963 | 229795 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 277 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004958.17286 | 2108195.3416 | 37.7689831073039 | -122.426164188445 | (37.7689831073039, -122.426164188445) | 8 | 4 | 5 | 28853 | 19 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |
| 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 | |
| 12723 | 229788 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1799 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005571.35245 | 2107231.70655 | 37.7663718340174 | -122.423974702579 | (37.7663718340174, -122.423974702579) | 8 | 4 | 5 | 28853 | 19 | |||
| 132381 | 229787 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1799 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005558.49234 | 2107230.4627 | 37.7663676926515 | -122.424019094899 | (37.7663676926515, -122.424019094899) | 8 | 4 | 5 | 28853 | 19 | |||
| 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 | |||
| 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 | |||
| 158970 | 95223 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 299 on 16th St Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774713 | 6004880 | 2106610 | 37.7646257206218 | -122.426321695151 | (37.7646257206218, -122.426321695151) | 8 | 4 | 5 | 28859 | 19 | |
| 174174 | 95221 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 299 on 16th St Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 774713 | 6004880 | 2106610 | 37.7646257206218 | -122.426321695151 | (37.7646257206218, -122.426321695151) | 8 | 4 | 5 | 28859 | 19 | ||
| 130757 | 35314 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 120 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | 6 | 3x3 | Permit Number 38781 | 6005865.10533901 | 2106546.77110861 | 37.7645077436281 | -122.422909979953 | (37.7645077436281, -122.422909979953) | 8 | 4 | 5 | 28859 | 19 |
| 82268 | 229743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 120 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005873.02878 | 2106520.6426 | 37.7644364480055 | -122.422880717778 | (37.7644364480055, -122.422880717778) | 8 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 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 | |||
| 20883 | 229739 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 28 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005381.68276 | 2105771.85713 | 37.7623527242205 | -122.424526883603 | (37.7623527242205, -122.424526883603) | 8 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 76307 | 229740 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 60 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005206.89439 | 2105762.97862 | 37.7623184735408 | -122.425130780182 | (37.7623184735408, -122.425130780182) | 8 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 130325 | 35308 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3524 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38776 | 6006060.26352617 | 2105533.64133784 | 37.761736937829 | -122.422162997439 | (37.761736937829, -122.422162997439) | 8 | 4 | 5 | 28859 | 19 | ||
| 46170 | 229805 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3526 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6006031.82091 | 2105526.37435 | 37.7617153800751 | -122.422260852855 | (37.7617153800751, -122.422260852855) | 8 | 4 | 5 | 28859 | 19 | |||
| 166276 | 95624 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3548 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767391 | 6005934 | 2105520 | 37.761692359374 | -122.422598723522 | (37.761692359374, -122.422598723522) | 8 | 4 | 5 | 28859 | 19 | |
| 181262 | 35309 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3614 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38777 | 6005480.32103823 | 2105501.15439096 | 37.7616150083325 | -122.424166477384 | (37.7616150083325, -122.424166477384) | 8 | 4 | 5 | 28859 | 19 | ||
| 49291 | 35310 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3620 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38778 | 6005440.34891977 | 2105498.91525501 | 37.7616066031849 | -122.424304565555 | (37.7616066031849, -122.424304565555) | 8 | 4 | 5 | 28859 | 19 | ||
| 37213 | 229796 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3620 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005429.44821 | 2105495.57142 | 37.7615968062711 | -122.42434202887 | (37.7615968062711, -122.42434202887) | 8 | 4 | 5 | 28859 | 19 | |||
| 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 | |
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | ||
| 99690 | 229838 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 28 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005984.45224 | 2105323.33984 | 37.7611552229594 | -122.422410255427 | (37.7611552229594, -122.422410255427) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 81761 | 10083 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 643 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2004 12:00:00 AM | 3 | 3X3 | 6005633.91176 | 2105224.85563 | 37.7608650279097 | -122.423615623972 | (37.7608650279097, -122.423615623972) | 2 | 4 | 5 | 28859 | 19 | ||
| 28580 | 10084 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 649 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2012 12:00:00 AM | 3 | 3X3 | 6005635.92874 | 2105201.33874 | 37.7608005699125 | -122.423606976082 | (37.7608005699125, -122.423606976082) | 2 | 4 | 5 | 28859 | 19 | ||
| 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 | ||
| 72032 | 229799 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 69 Lapidge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006019.54288 | 2105120.91089 | 37.7606013799572 | -122.422274509073 | (37.7606013799572, -122.422274509073) | 2 | 4 | 5 | 28859 | 19 | |||
| 41705 | 229798 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 69 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006019.29949 | 2105109.06322 | 37.7605688353024 | -122.422274509073 | (37.7605688353024, -122.422274509073) | 2 | 4 | 5 | 28859 | 19 | |||
| 29877 | 39158 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 69 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40827 | 6006035.82025068 | 2105107.15671694 | 37.7605645323651 | -122.422217235752 | (37.7605645323651, -122.422217235752) | 2 | 4 | 5 | 28859 | 19 | ||
| 42787 | 39159 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 69 Lapidge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40827 | 6006035.82025068 | 2105107.15671694 | 37.7605645323651 | -122.422217235752 | (37.7605645323651, -122.422217235752) | 2 | 4 | 5 | 28859 | 19 | ||
| 40136 | 229839 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 70 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005996.27622 | 2105099.28876 | 37.7605406982241 | -122.422353441684 | (37.7605406982241, -122.422353441684) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 95435 | 229797 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 79 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006025.25664 | 2105073.13553 | 37.7604705223053 | -122.422251353344 | (37.7604705223053, -122.422251353344) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | ||
| 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 | |||
| 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 | ||
| 75595 | 63245 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3676 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/23/1988 12:00:00 AM | 3 | 3x3 | Permit Number 24178 | 6005805.15699581 | 2104348.35401431 | 37.7584680245234 | -122.422961063691 | (37.7584680245234, -122.422961063691) | 2 | 4 | 5 | 28859 | 19 |
| 12595 | 229844 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3676 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | 6005793.11557 | 2104343.58039 | 37.7584542377953 | -122.423002369088 | (37.7584542377953, -122.423002369088) | 2 | 4 | 5 | 28859 | 19 | |||
| 157178 | 229840 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3732 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005421.91572 | 2104323.47522 | 37.7583780804987 | -122.42428471508 | (37.7583780804987, -122.42428471508) | 2 | 4 | 5 | 28859 | 19 | |||
| 121545 | 104351 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3732 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2013 12:00:00 AM | 3x3 | Permit Number 769484 | 6005428.9 | 2104316.5 | 37.7583593225521 | -122.424260064239 | (37.7583593225521, -122.424260064239) | 2 | 4 | 5 | 28859 | 19 | ||
| 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 |
| 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 | |||
| 130410 | 229841 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3772 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6005193.66428 | 2104309.81334 | 37.7583276770852 | -122.425073138141 | (37.7583276770852, -122.425073138141) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 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 |
| 100803 | 229843 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3731 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005450.41756 | 2104282.65689 | 37.7582676122766 | -122.424183240071 | (37.7582676122766, -122.424183240071) | 2 | 4 | 5 | 28859 | 19 |
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) );