trees
132 rows where Neighborhoods (old) = 2 and qSpecies_id = 50 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193991 | 52376 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 25 Fair Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | Permit Number 48505 | 6006761.98937592 | 2099585.56782641 | 37.7454444472056 | -122.419314037874 | (37.7454444472056, -122.419314037874) | 2 | 7 | 7 | 28859 | 2 | ||
188939 | 104962 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 1474X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 74 Aztec St. | 6008023 | 2099506 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | 2 | 7 | 7 | 28859 | 2 | ||
181833 | 226412 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 282 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1987 12:00:00 AM | 14 | Width 3ft | Permit Number 24387 | 6008267.80034 | 2100190.98708 | 37.7471914863912 | -122.41414999144 | (37.7471914863912, -122.41414999144) | 2 | 7 | 7 | 28859 | 2 | |
181781 | 49967 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3228@ PRECITA Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/02/2003 12:00:00 AM | Permit Number 46719 | 6008983.82935555 | 2099882.83427264 | 37.7463855595114 | -122.411652240395 | (37.7463855595114, -122.411652240395) | 2 | 7 | 7 | 28859 | 2 | ||
179723 | 226405 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1405 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008013.30182 | 2099943.8587 | 37.746498628925 | -122.415012541103 | (37.746498628925, -122.415012541103) | 2 | 7 | 7 | 28859 | 2 | |||
174953 | 226307 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 303 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007092.99842 | 2096727.14909 | 37.7376145033994 | -122.417966864376 | (37.7376145033994, -122.417966864376) | 2 | 7 | 7 | 28859 | 2 | |||
172836 | 37451 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39924 | 6009949.70212209 | 2098546.33795552 | 37.7427699663381 | -122.408218103257 | (37.7427699663381, -122.408218103257) | 10 | 7 | 7 | 28859 | 2 | ||
171578 | 226306 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 92 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006186.62899 | 2097537.37358 | 37.7397881459032 | -122.421158135656 | (37.7397881459032, -122.421158135656) | 2 | 7 | 7 | 28859 | 2 | |||
170353 | 68103 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 67 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | 8 | 3x3 | Permit Number 31849 | 6008260.07157656 | 2099634.80152159 | 37.7456638906333 | -122.414137374358 | (37.7456638906333, -122.414137374358) | 2 | 7 | 7 | 28859 | 2 |
168980 | 226358 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 603 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006078.34429 | 2099888.6136 | 37.7462380152724 | -122.421699497839 | (37.7462380152724, -122.421699497839) | 2 | 7 | 5 | 28859 | 2 | |||
168394 | 34557 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Nebraska St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 38265 | 6009291.02762051 | 2098031.45158376 | 37.7413192965243 | -122.410459272722 | (37.7413192965243, -122.410459272722) | 10 | 7 | 7 | 28859 | 2 | ||
166899 | 229893 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 57 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008237.21282 | 2099854.86207 | 37.7462668439462 | -122.414231983545 | (37.7462668439462, -122.414231983545) | 2 | 7 | 7 | 28859 | 2 | |||
166585 | 226406 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1417 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008014.49827 | 2099882.17848 | 37.7463293360461 | -122.415004038921 | (37.7463293360461, -122.415004038921) | 2 | 7 | 7 | 28859 | 2 | |||
164689 | 229863 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1511 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010172.47865 | 2100425.75688 | 37.7479429122343 | -122.407580282 | (37.7479429122343, -122.407580282) | 2 | 7 | 7 | 28859 | 2 | |||
163174 | 63722 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 282 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | Permit Number 24387 | 6008301.23026628 | 2100182.88719283 | 37.7471711235701 | -122.414033820067 | (37.7471711235701, -122.414033820067) | 2 | 7 | 7 | 28859 | 2 | ||
157820 | 226386 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 354 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006131.45892 | 2098074.37938 | 37.7412595329921 | -122.421387016722 | (37.7412595329921, -122.421387016722) | 2 | 7 | 7 | 28859 | 2 | |||
156536 | 68108 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 83 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1993 12:00:00 AM | Permit Number 31854 | 6008265.27071667 | 2099541.297285 | 37.7454074408153 | -122.414112782506 | (37.7454074408153, -122.414112782506) | 2 | 7 | 7 | 28859 | 2 | ||
154193 | 117396 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 330X Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | Permit Number 776356 | 6007069.63693 | 2096670.72705 | 37.7374582661153 | -122.418043637637 | (37.7374582661153, -122.418043637637) | 2 | 7 | 7 | 28859 | 2 | ||
149748 | 226387 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 28 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006154.51065 | 2098290.0214 | 37.7418529371529 | -122.421322621667 | (37.7418529371529, -122.421322621667) | 2 | 7 | 7 | 28859 | 2 | |||
148309 | 226304 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1425 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008016.14912 | 2099877.20359 | 37.7463157688762 | -122.414997978399 | (37.7463157688762, -122.414997978399) | 2 | 7 | 7 | 28859 | 2 | |||
146523 | 226382 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 58 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009331.97291 | 2097098.94639 | 37.7387611354248 | -122.410251874634 | (37.7387611354248, -122.410251874634) | 10 | 7 | 7 | 28859 | 2 | |||
146505 | 68109 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 87 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1993 12:00:00 AM | Permit Number 31855 | 6008266.5705023 | 2099517.92121492 | 37.7453433283283 | -122.414106634567 | (37.7453433283283, -122.414106634567) | 2 | 7 | 7 | 28859 | 2 | ||
146308 | 226381 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 60 Nebraska St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6009264.00065 | 2097705.48363 | 37.7404227444144 | -122.410529710297 | (37.7404227444144, -122.410529710297) | 10 | 7 | 7 | 28859 | 2 | |||
143048 | 36511 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 15 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50549 | 6007227.68347498 | 2097723.04326722 | 37.7403565876102 | -122.417571756215 | (37.7403565876102, -122.417571756215) | 2 | 7 | 7 | 28859 | 2 | ||
140846 | 229886 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1420 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007989.59839 | 2099723.5875 | 37.7458924813579 | -122.41507891646 | (37.7458924813579, -122.41507891646) | 2 | 7 | 7 | 28859 | 2 | |||
135298 | 226383 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 45 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007419.20582 | 2097997.75063 | 37.7411216480553 | -122.416929004483 | (37.7411216480553, -122.416929004483) | 2 | 7 | 7 | 28859 | 2 | |||
135033 | 239543 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 91 Bennington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007186.36237 | 2097372.94469 | 37.7393929694044 | -122.417689820148 | (37.7393929694044, -122.417689820148) | 2 | 7 | 7 | 28859 | 2 | |
134714 | 248273 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 155 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6006714.66464 | 2098690.19871 | 37.7429832995482 | -122.419414171229 | (37.7429832995482, -122.419414171229) | 2 | 7 | 7 | 28859 | 2 | |||
131818 | 226398 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1480 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008004.95256 | 2099511.34192 | 37.7453105651388 | -122.415010803607 | (37.7453105651388, -122.415010803607) | 2 | 7 | 7 | 28859 | 2 | |||
130952 | 226309 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 161 Newman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007378.4424 | 2096771.82308 | 37.737753229234 | -122.416983110403 | (37.737753229234, -122.416983110403) | 2 | 7 | 7 | 28859 | 2 | |||
130148 | 226400 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1480 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008001.07248 | 2099553.66374 | 37.7454265533887 | -122.415027215335 | (37.7454265533887, -122.415027215335) | 2 | 7 | 7 | 28859 | 2 | |||
129802 | 226397 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1490 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008007.72496 | 2099487.35787 | 37.745244866072 | -122.414999519809 | (37.745244866072, -122.414999519809) | 2 | 7 | 7 | 28859 | 2 | |||
128396 | 229882 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3770 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6008416.68038 | 2097349.45644 | 37.7393976324023 | -122.41343424801 | (37.7393976324023, -122.41343424801) | 2 | 7 | 7 | 28859 | 2 | |||
126636 | 229890 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 67 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008246.22081 | 2099723.2099 | 37.7459058623841 | -122.414191522144 | (37.7459058623841, -122.414191522144) | 2 | 7 | 7 | 28859 | 2 | |||
126418 | 36541 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3784 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39414 | 6008400.50795497 | 2097269.02278879 | 37.7391758711573 | -122.413484478256 | (37.7391758711573, -122.413484478256) | 2 | 7 | 7 | 28859 | 2 | ||
123971 | 229884 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 137 Bradford St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 5ft | 6009563.00843 | 2097787.48407 | 37.7406646584401 | -122.409501640412 | (37.7406646584401, -122.409501640412) | 10 | 7 | 7 | 28859 | 2 | |||
123784 | 226378 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 511 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008209.35637 | 2096429.78748 | 37.7368607798011 | -122.414086039755 | (37.7368607798011, -122.414086039755) | 2 | 7 | 7 | 28859 | 2 | |||
123700 | 248006 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Franconia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009948.03902 | 2098416.30132 | 37.7424128208876 | -122.408214684483 | (37.7424128208876, -122.408214684483) | 10 | 7 | 7 | 28859 | 2 | |||
121675 | 226384 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 15 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007204.63358 | 2097592.37529 | 37.7399965053243 | -122.417642194748 | (37.7399965053243, -122.417642194748) | 2 | 7 | 7 | 28859 | 2 | |||
120181 | 229745 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6006000.19569 | 2099145.76871 | 37.7441939246187 | -122.421916967417 | (37.7441939246187, -122.421916967417) | 2 | 7 | 5 | 28859 | 2 | |||
120105 | 37443 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 423 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39917 | 6010005.91327801 | 2098599.86014619 | 37.742920074008 | -122.408027513819 | (37.742920074008, -122.408027513819) | 10 | 7 | 7 | 28859 | 2 | ||
118897 | 224296 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 5 Powhattan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | 6x15 | Permit Number 780759 | 6007487.03456 | 2098209.30712 | 37.7417063503734 | -122.416709460186 | (37.7417063503734, -122.416709460186) | 2 | 7 | 7 | 28859 | 2 | |
117771 | 226385 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 352 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006123.1231 | 2098057.1404 | 37.7412117286404 | -122.421414615119 | (37.7412117286404, -122.421414615119) | 2 | 7 | 7 | 28859 | 2 | |||
116554 | 232376 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 50 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x9 | 6008171 | 2099926 | 37.746458453366 | -122.414465973024 | (37.746458453366, -122.414465973024) | 2 | 7 | 7 | 28859 | 2 | |||
115180 | 226379 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 424 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008895.67252 | 2096317.34788 | 37.7365905694901 | -122.411705190752 | (37.7365905694901, -122.411705190752) | 10 | 7 | 7 | 28859 | 2 | |||
112368 | 115507 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1501x YORK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010110 | 2100575 | 37.748349203538 | -122.407806853602 | (37.748349203538, -122.407806853602) | 2 | 4 | 7 | 28859 | 2 | |||
112161 | 229887 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 87 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008255.99327 | 2099554.30466 | 37.745442635078 | -122.414145782603 | (37.745442635078, -122.414145782603) | 2 | 7 | 7 | 28859 | 2 | |||
111960 | 68104 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 77 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | 8 | 5x7 | Permit Number 31850 | 6008263.32103821 | 2099576.36139011 | 37.7455036095439 | -122.414122004435 | (37.7455036095439, -122.414122004435) | 2 | 7 | 7 | 28859 | 2 |
111735 | 37446 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 428 Franconia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1998 12:00:00 AM | Permit Number 39919 | 6009952.87320759 | 2098588.12487014 | 37.7428848816788 | -122.408210085028 | (37.7428848816788, -122.408210085028) | 10 | 7 | 7 | 28859 | 2 | |||
111132 | 37445 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 428 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39919 | 6009952.87320759 | 2098588.12487014 | 37.7428848816788 | -122.408210085028 | (37.7428848816788, -122.408210085028) | 10 | 7 | 7 | 28859 | 2 | ||
110808 | 226410 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 340 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007045.3382 | 2096649.72314 | 37.7373992263821 | -122.418126161295 | (37.7373992263821, -122.418126161295) | 2 | 7 | 7 | 28859 | 2 | |||
109988 | 240741 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 91 Bennington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007184.54991 | 2097351.72127 | 37.739334592605 | -122.417694582949 | (37.739334592605, -122.417694582949) | 2 | 7 | 7 | 28859 | 2 | |
108736 | 226399 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1480 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008004.14123 | 2099529.6733 | 37.7453608534324 | -122.41501490632 | (37.7453608534324, -122.41501490632) | 2 | 7 | 7 | 28859 | 2 | |||
106394 | 226408 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 324 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006517.91503 | 2097301.91264 | 37.739160293208 | -122.419995981327 | (37.739160293208, -122.419995981327) | 2 | 7 | 7 | 28859 | 2 | |||
106216 | 226380 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 60 Nebraska St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6009262.96454 | 2097691.62969 | 37.7403846464258 | -122.410532314727 | (37.7403846464258, -122.410532314727) | 10 | 7 | 7 | 28859 | 2 | |||
106174 | 248027 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 423 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009988.36995 | 2098561.68629 | 37.7428142746487 | -122.40808548247 | (37.7428142746487, -122.40808548247) | 10 | 7 | 7 | 28859 | 2 | |||
105247 | 40466 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 45 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/1999 12:00:00 AM | Permit Number 41551 | 6007432.5015154 | 2097996.59571862 | 37.7411192248043 | -122.416882950838 | (37.7411192248043, -122.416882950838) | 2 | 7 | 7 | 28859 | 2 | ||
102856 | 226389 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 23 Fair Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006752.48721 | 2099574.02703 | 37.7454122236106 | -122.419346076359 | (37.7454122236106, -122.419346076359) | 2 | 7 | 7 | 28859 | 2 | |||
102346 | 35943 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 303 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2016 12:00:00 AM | 3 | Permit Number 39390 | 6007111.66828124 | 2096780.53419663 | 37.7377621378422 | -122.417906096842 | (37.7377621378422, -122.417906096842) | 2 | 7 | 7 | 28859 | 2 | |
100983 | 226403 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 78 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008209.69188 | 2099648.73947 | 37.7456993312598 | -122.414312566376 | (37.7456993312598, -122.414312566376) | 2 | 7 | 7 | 28859 | 2 | |||
99789 | 229862 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1511 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010167.1335 | 2100435.43231 | 37.747969179639 | -122.40759944746 | (37.747969179639, -122.40759944746) | 2 | 7 | 7 | 28859 | 2 | |||
97822 | 226404 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 47 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007592.36819 | 2099969.05914 | 37.7465441607 | -122.416469871814 | (37.7465441607, -122.416469871814) | 2 | 7 | 7 | 28859 | 2 | |||
96561 | 51473 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 511 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/2004 12:00:00 AM | Permit Number 47785 | 6008227.06002157 | 2096462.73555684 | 37.7369522423723 | -122.414027160396 | (37.7369522423723, -122.414027160396) | 2 | 7 | 7 | 28859 | 2 | ||
95305 | 117397 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 330X Bennington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | Permit Number 776356 | 6007069.63693 | 2096670.72705 | 37.7374582661153 | -122.418043637637 | (37.7374582661153, -122.418043637637) | 2 | 7 | 7 | 28859 | 2 | ||
91115 | 239542 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 91 Bennington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007187.05082 | 2097389.73315 | 37.7394391055351 | -122.417688629421 | (37.7394391055351, -122.417688629421) | 2 | 7 | 7 | 28859 | 2 | |
90056 | 28275 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 304 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/17/2016 12:00:00 AM | 6 | 2X3 | 6006647.7252044 | 2098034.3646343 | 37.7411787556411 | -122.419599108791 | (37.7411787556411, -122.419599108791) | 2 | 7 | 7 | 28859 | 2 | ||
88179 | 43128 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 84 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | Permit Number 42946 | 6006098.21265371 | 2097579.74571646 | 37.73989950547 | -122.421466850906 | (37.73989950547, -122.421466850906) | 2 | 7 | 7 | 28859 | 2 | ||
86331 | 229860 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3224 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008991.73751 | 2099895.44974 | 37.7464206424026 | -122.411625786002 | (37.7464206424026, -122.411625786002) | 2 | 7 | 7 | 28859 | 2 | |||
84648 | 68106 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 80 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1993 12:00:00 AM | Permit Number 31852 | 6008212.57916811 | 2099552.28991109 | 37.7454346644163 | -122.414295759595 | (37.7454346644163, -122.414295759595) | 2 | 7 | 7 | 28859 | 2 | ||
84496 | 226411 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 950 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009265.11627 | 2098029.82714 | 37.741313383517 | -122.410548750743 | (37.741313383517, -122.410548750743) | 10 | 7 | 7 | 28859 | 2 | |||
83706 | 226401 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 96 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008220.52934 | 2099483.50303 | 37.7452462375173 | -122.414263403134 | (37.7452462375173, -122.414263403134) | 2 | 7 | 7 | 28859 | 2 | |||
79540 | 115508 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1501x YORK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010110 | 2100575 | 37.748349203538 | -122.407806853602 | (37.748349203538, -122.407806853602) | 2 | 4 | 7 | 28859 | 2 | |||
78208 | 36018 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 93 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39164 | 6006753.30500561 | 2099126.43768618 | 37.7441832900966 | -122.419311502826 | (37.7441832900966, -122.419311502826) | 2 | 7 | 7 | 28859 | 2 | ||
75930 | 226391 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1437 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008021.55589 | 2099786.31396 | 37.7460665100597 | -122.414972850429 | (37.7460665100597, -122.414972850429) | 2 | 7 | 7 | 28859 | 2 | |||
74771 | 226308 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 161 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007401.10475 | 2096768.52961 | 37.7377454608683 | -122.416904522239 | (37.7377454608683, -122.416904522239) | 2 | 7 | 7 | 28859 | 2 | |||
74571 | 40729 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 23 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41708 | 6007052.60593678 | 2095671.4040371 | 37.7347133867785 | -122.418031698759 | (37.7347133867785, -122.418031698759) | 2 | 7 | 7 | 28859 | 2 | ||
73107 | 115506 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1501x YORK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010110 | 2100575 | 37.748349203538 | -122.407806853602 | (37.748349203538, -122.407806853602) | 2 | 4 | 7 | 28859 | 2 | |||
71284 | 24293 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 302 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/03/2011 12:00:00 AM | 3 | 2x2 | 6006647.73618 | 2098006.46065 | 37.741102138158 | -122.419597091541 | (37.741102138158, -122.419597091541) | 2 | 7 | 7 | 28859 | 2 | ||
70598 | 40721 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 58 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41700 | 6009320.76573459 | 2097115.38530681 | 37.7388056449049 | -122.410291784296 | (37.7388056449049, -122.410291784296) | 10 | 7 | 7 | 28859 | 2 | ||
70019 | 229864 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 76 Peralta Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6010511.83754 | 2100376.53881 | 37.7478267603098 | -122.406403320374 | (37.7478267603098, -122.406403320374) | 2 | 7 | 7 | 28859 | 2 | |||
69326 | 229892 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008238.53675 | 2099832.54368 | 37.7462056369848 | -122.414225826762 | (37.7462056369848, -122.414225826762) | 2 | 7 | 7 | 28859 | 2 | |||
69053 | 226393 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1451 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008028.94032 | 2099726.7877 | 37.7459034791769 | -122.414943103567 | (37.7459034791769, -122.414943103567) | 2 | 7 | 7 | 28859 | 2 | |||
64355 | 36539 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3770 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39412 | 6008405.93467714 | 2097334.19751076 | 37.7393551313718 | -122.413470323165 | (37.7393551313718, -122.413470323165) | 2 | 7 | 7 | 28859 | 2 | ||
58969 | 255166 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 115 Wool St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779581 | 6007398.90831 | 2097677.8344 | 37.7402420872899 | -122.416976524667 | (37.7402420872899, -122.416976524667) | 2 | 7 | 7 | 28859 | 2 | |
58760 | 226396 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1483 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008038.28994 | 2099516.86307 | 37.7453275982942 | -122.41489591881 | (37.7453275982942, -122.41489591881) | 2 | 7 | 7 | 28859 | 2 | |||
56577 | 35969 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 176 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39127 | 6006023.56999156 | 2096341.44627535 | 37.7364952030819 | -122.421637006977 | (37.7364952030819, -122.421637006977) | 2 | 7 | 7 | 28859 | 2 | ||
53978 | 34556 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Nebraska St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 38265 | 6009291.02762051 | 2098031.45158376 | 37.7413192965243 | -122.410459272722 | (37.7413192965243, -122.410459272722) | 10 | 7 | 7 | 28859 | 2 | ||
51890 | 229889 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 77 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008249.88149 | 2099665.88685 | 37.7457486716635 | -122.414174809135 | (37.7457486716635, -122.414174809135) | 2 | 7 | 7 | 28859 | 2 | |||
51307 | 226395 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1467 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008034.1838 | 2099620.63234 | 37.7456122948636 | -122.414917460292 | (37.7456122948636, -122.414917460292) | 2 | 7 | 7 | 28859 | 2 | |||
48985 | 100215 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 7x6 | 6008249 | 2099678 | 37.7457818821655 | -122.414178714053 | (37.7457818821655, -122.414178714053) | 2 | 7 | 7 | 28859 | 2 | |||
46491 | 226357 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 645 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005980.00754 | 2099557.6277 | 37.7453236574624 | -122.422016025938 | (37.7453236574624, -122.422016025938) | 2 | 7 | 5 | 28859 | 2 | |||
44395 | 226394 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1451 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008031.02829 | 2099712.86133 | 37.7458653577975 | -122.414934898137 | (37.7458653577975, -122.414934898137) | 2 | 7 | 7 | 28859 | 2 | |||
42902 | 104963 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1474X SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3z3 | Permit Number 770948 | 6008023 | 2099506 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | 2 | 7 | 7 | 28859 | 2 | ||
42122 | 93487 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 643 San Jose Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2010 12:00:00 AM | 3x3 | Permit Number 53236 | 6005997.4 | 2099554.6 | 37.745316324998 | -122.421955670553 | (37.745316324998, -122.421955670553) | 2 | 7 | 5 | 28859 | 2 | |||
40026 | 229885 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1420 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007989.39364 | 2099739.34159 | 37.7459357270683 | -122.415080739378 | (37.7459357270683, -122.415080739378) | 2 | 7 | 7 | 28859 | 2 | |||
40005 | 229894 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1435 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008020.95699 | 2099824.31502 | 37.7461708188376 | -122.414977610555 | (37.7461708188376, -122.414977610555) | 2 | 7 | 7 | 28859 | 2 | |||
39438 | 229804 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 10 Crescent Ave | 7 | Side Yard : Yard | Tree | Private 2 | 6 | Width 5ft | 6005354.49537 | 2095898.81655 | 37.7352420900484 | -122.423918818711 | (37.7352420900484, -122.423918818711) | 2 | 7 | 7 | 28859 | 2 | |||
39052 | 229883 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3784 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008413.69404 | 2097282.59684 | 37.7392138829104 | -122.413439846296 | (37.7392138829104, -122.413439846296) | 2 | 7 | 7 | 28859 | 2 | |||
37653 | 248002 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 428 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009958.97644 | 2098527.35445 | 37.74271836107 | -122.408184696582 | (37.74271836107, -122.408184696582) | 10 | 7 | 7 | 28859 | 2 | |||
37084 | 71739 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1467 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1995 12:00:00 AM | 3x3 | Permit Number 56975 | 6008043.26276721 | 2099626.05915094 | 37.7456277058322 | -122.41488645052 | (37.7456277058322, -122.41488645052) | 2 | 7 | 7 | 28859 | 2 |
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) );