trees
1,914 rows where qSpecies_id = 45 sorted by qCaretaker_id
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87 | 259654 | DPW Maintained 1 | :: 45 | 101x Cora St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 88 | 259653 | DPW Maintained 1 | :: 45 | 99x Cora St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 89 | 259623 | DPW Maintained 1 | :: 45 | 1498x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 326 | 228441 | DPW Maintained 1 | :: 45 | 419 Haight St | 1 | : | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 6 | Width 3ft | 6004104.36681 | 2109385.12417 | 37.7722016657998 | -122.429202297052 | (37.7722016657998, -122.429202297052) | 7 | 9 | 11 | 29492 | 10 | ||
| 365 | 184621 | DPW Maintained 1 | :: 45 | 3100x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5984373.2194 | 2102928.6488 | 37.7533372599652 | -122.496976365214 | (37.7533372599652, -122.496976365214) | 1 | 8 | 3 | 56 | 35 | |||
| 375 | 115067 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 519 | 259637 | DPW Maintained 1 | :: 45 | 95 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010745.67067 | 2087724.79538 | 37.7131008096728 | -122.404704194453 | (37.7131008096728, -122.404704194453) | 9 | 7 | 8 | 309 | 39 | ||
| 570 | 259611 | DPW Maintained 1 | :: 45 | 1420 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008434.50928 | 2087674.99824 | 37.7128346308013 | -122.412688855365 | (37.7128346308013, -122.412688855365) | 9 | 7 | 8 | 309 | 39 | ||
| 2626 | 259634 | DPW Maintained 1 | :: 45 | 83 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010826.96041 | 2087682.93228 | 37.7129904051639 | -122.404420283412 | (37.7129904051639, -122.404420283412) | 9 | 7 | 8 | 309 | 39 | ||
| 2635 | 259636 | DPW Maintained 1 | :: 45 | 98x Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 3035 | 259640 | DPW Maintained 1 | :: 45 | 198x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 3194 | 259639 | DPW Maintained 1 | :: 45 | 122 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010584.82353 | 2087852.62198 | 37.7134428042481 | -122.405269135112 | (37.7134428042481, -122.405269135112) | 9 | 7 | 8 | 309 | 39 | ||
| 3520 | 259641 | DPW Maintained 1 | :: 45 | 234 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009944.29036 | 2088126.34972 | 37.7141585726669 | -122.407502340313 | (37.7141585726669, -122.407502340313) | 9 | 7 | 8 | 309 | 39 | ||
| 3621 | 259642 | DPW Maintained 1 | :: 45 | 238 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009920.83207 | 2088134.90851 | 37.7141807602716 | -122.407584024659 | (37.7141807602716, -122.407584024659) | 9 | 7 | 8 | 309 | 39 | ||
| 4234 | 259615 | DPW Maintained 1 | :: 45 | 935 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009702.19768 | 2087158.08788 | 37.7114863694621 | -122.408270858441 | (37.7114863694621, -122.408270858441) | 9 | 7 | 8 | 309 | 39 | ||
| 4471 | 259626 | DPW Maintained 1 | :: 45 | 1499x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 4944 | 259613 | DPW Maintained 1 | :: 45 | 1000 Visitacion Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 5006 | 259624 | DPW Maintained 1 | :: 45 | 1401x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 5982 | 259609 | DPW Maintained 1 | :: 45 | 1035 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009443.72066 | 2087255.36906 | 37.711739006489 | -122.40917108656 | (37.711739006489, -122.40917108656) | 9 | 7 | 8 | 309 | 39 | ||
| 6300 | 259616 | DPW Maintained 1 | :: 45 | 941 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009687.32277 | 2087163.71083 | 37.7115009759818 | -122.408322666595 | (37.7115009759818, -122.408322666595) | 9 | 7 | 8 | 309 | 39 | ||
| 6366 | 117001 | DPW Maintained 1 | :: 45 | 1X Bernal Heights Blvd | 1 | Front Yard : Yard | Tree | DPW 1 | |||||||||||||||
| 6535 | 259627 | DPW Maintained 1 | :: 45 | 1499x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 7054 | 259630 | DPW Maintained 1 | :: 45 | 25 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011219.86081 | 2087480.59399 | 37.7124567737707 | -122.403048058633 | (37.7124567737707, -122.403048058633) | 9 | 7 | 8 | 309 | 39 | ||
| 7294 | 259631 | DPW Maintained 1 | :: 45 | 86 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010819.87099 | 2087731.57587 | 37.7131235744523 | -122.404448208813 | (37.7131235744523, -122.404448208813) | 9 | 7 | 8 | 309 | 39 | ||
| 7724 | 259614 | DPW Maintained 1 | :: 45 | 928 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009731.2164 | 2087189.88087 | 37.7115752914499 | -122.408172802554 | (37.7115752914499, -122.408172802554) | 9 | 7 | 8 | 309 | 39 | ||
| 7740 | 142745 | DPW Maintained 1 | :: 45 | 700x COLUMBUS AVE | 8 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 6009127.5357 | 2120116.4029 | 37.8019502507169 | -122.412585395041 | (37.8019502507169, -122.412585395041) | 3 | 1 | 10 | 308 | 4 | |||
| 7789 | 259629 | DPW Maintained 1 | :: 45 | 18 Arleta Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011290.10954 | 2087489.4095 | 37.7124849020689 | -122.402805875722 | (37.7124849020689, -122.402805875722) | 9 | 7 | 8 | 309 | 39 | |||
| 7856 | 259620 | DPW Maintained 1 | :: 45 | 1230 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008944.20258 | 2087484.57598 | 37.7123403644372 | -122.410913742428 | (37.7123403644372, -122.410913742428) | 9 | 7 | 8 | 309 | 39 | ||
| 8417 | 259628 | DPW Maintained 1 | :: 45 | 100 Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008465.19154 | 2087632.83273 | 37.7127205750598 | -122.412579828323 | (37.7127205750598, -122.412579828323) | 9 | 7 | 8 | 309 | 39 | ||
| 8458 | 259610 | DPW Maintained 1 | :: 45 | 1107 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6009254.2033 | 2087326.13058 | 37.7119226839796 | -122.409831104788 | (37.7119226839796, -122.409831104788) | 9 | 7 | 8 | 309 | 39 | ||||
| 8942 | 259632 | DPW Maintained 1 | :: 45 | 31 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011179.21594 | 2087501.52553 | 37.7125119777417 | -122.40319001201 | (37.7125119777417, -122.40319001201) | 9 | 7 | 8 | 309 | 39 | ||
| 10803 | 259618 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 11414 | 173708 | DPW Maintained 1 | :: 45 | 126 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001214 | 2098705 | 37.7427125900371 | -122.438434982469 | (37.7427125900371, -122.438434982469) | 2 | 7 | 5 | 63 | 7 | ||||
| 12259 | 259644 | DPW Maintained 1 | :: 45 | 242 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009897.37379 | 2088143.4673 | 37.7142029478201 | -122.40766570902 | (37.7142029478201, -122.40766570902) | 9 | 7 | 8 | 309 | 39 | ||
| 12379 | 259619 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 12908 | 259612 | DPW Maintained 1 | :: 45 | 1000 Visitacion Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 12997 | 258944 | DPW Maintained 1 | :: 45 | 190 Freelon St | 1 | Sidewalk: Curb side : Yard | Landscaping | DPW 1 | Width 2ft | 6013228 | 2111376 | 37.7781804260272 | -122.397782321929 | (37.7781804260272, -122.397782321929) | 6 | 2 | 9 | 28856 | 34 | ||||
| 13540 | 259645 | DPW Maintained 1 | :: 45 | 243 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009883.66375 | 2088105.89025 | 37.7140990014395 | -122.407710448479 | (37.7140990014395, -122.407710448479) | 9 | 7 | 8 | 309 | 39 | ||
| 14450 | 259622 | DPW Maintained 1 | :: 45 | 1498x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 14847 | 259625 | DPW Maintained 1 | :: 45 | 1401x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 15847 | 259635 | DPW Maintained 1 | :: 45 | 98x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 16880 | 259621 | DPW Maintained 1 | :: 45 | 1398x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 16911 | 259646 | DPW Maintained 1 | :: 45 | 266 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009756.62408 | 2088194.82004 | 37.7143360719186 | -122.408155816313 | (37.7143360719186, -122.408155816313) | 9 | 7 | 8 | 309 | 39 | ||
| 17095 | 259633 | DPW Maintained 1 | :: 45 | 37 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011138.57107 | 2087522.45708 | 37.7125671815686 | -122.403331965599 | (37.7125671815686, -122.403331965599) | 9 | 7 | 8 | 309 | 39 | ||
| 17295 | 259617 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 17929 | 259649 | DPW Maintained 1 | :: 45 | 700 Delta St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 17931 | 259643 | DPW Maintained 1 | :: 45 | 241 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 18667 | 259652 | DPW Maintained 1 | :: 45 | 99x Cora St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 18887 | 259638 | DPW Maintained 1 | :: 45 | 99x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 19114 | 259651 | DPW Maintained 1 | :: 45 | 598x Rutland St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 25364 | 244493 | DPW Maintained 1 | :: 45 | 418 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/30/2011 12:00:00 AM | 2 | Width 0ft | 6004092.0994 | 2109430.4944 | 37.7723255469078 | -122.429247966827 | (37.7723255469078, -122.429247966827) | 7 | 9 | 11 | 29492 | 10 | ||
| 28186 | 185060 | DPW Maintained 1 | :: 45 | 10x El Mirasol Pl | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5987413.8008 | 2096060.1353 | 37.7346558528299 | -122.485957413668 | (37.7346558528299, -122.485957413668) | 1 | 8 | 3 | 64 | 35 | |||
| 30439 | 10286 | DPW Maintained 1 | :: 45 | 412 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3x3 | 6004126.8809 | 2109434.3591 | 37.7723381274034 | -122.429127930043 | (37.7723381274034, -122.429127930043) | 7 | 9 | 11 | 29492 | 10 | |||
| 34000 | 184614 | DPW Maintained 1 | :: 45 | 3600x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5982812.7565 | 2102876.5318 | 37.7531025964328 | -122.502368824356 | (37.7531025964328, -122.502368824356) | 1 | 8 | 3 | 56 | 35 | |||
| 35508 | 3826 | DPW Maintained 1 | :: 45 | 120 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/1992 12:00:00 AM | 3 | 3X3 | 6016868.5122165 | 2095917.6664165 | 37.7359371538987 | -122.384111573291 | (37.7359371538987, -122.384111573291) | 10 | 3 | 8 | 58 | 1 | ||
| 35792 | 25491 | DPW Maintained 1 | :: 45 | 645 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/29/2005 12:00:00 AM | 8 | 3X3 | 6003026.26997 | 2109233.55885 | 37.7717244144917 | -122.43292069335 | (37.7717244144917, -122.43292069335) | 15 | 5 | 11 | 29492 | 9 | ||
| 39172 | 184634 | DPW Maintained 1 | :: 45 | 4100x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5981271.0577 | 2102821.0876 | 37.7528596561113 | -122.507696113948 | (37.7528596561113, -122.507696113948) | 1 | 8 | 3 | 56 | 35 | |||
| 39743 | 25492 | DPW Maintained 1 | :: 45 | 645 Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/15/2001 12:00:00 AM | 5 | 3X3 | 6003043.5783 | 2109236.3656 | 37.7717331028377 | -122.432861023333 | (37.7717331028377, -122.432861023333) | 15 | 5 | 11 | 29492 | 9 | ||
| 45444 | 10257 | DPW Maintained 1 | :: 45 | 155 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2006 12:00:00 AM | 6 | 3X3 | 6005354.14588 | 2109555.43017 | 37.7727399559066 | -122.424891318606 | (37.7727399559066, -122.424891318606) | 7 | 9 | 11 | 28852 | 10 | ||
| 49325 | 10299 | DPW Maintained 1 | :: 45 | 559 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6003469.25661 | 2109295.83619 | 37.7719205287291 | -122.431392821626 | (37.7719205287291, -122.431392821626) | 15 | 9 | 11 | 29492 | 10 | |||
| 49806 | 184900 | DPW Maintained 1 | :: 45 | 3100x Noriega St | 2 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5984148.1689 | 2102921.2035 | 37.7533036269678 | -122.497754074885 | (37.7533036269678, -122.497754074885) | 1 | 8 | 3 | 56 | 35 | |||
| 50710 | 184609 | DPW Maintained 1 | :: 45 | 3400x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5983436.8063 | 2102896.8371 | 37.7531949966988 | -122.500212272852 | (37.7531949966988, -122.500212272852) | 1 | 8 | 3 | 56 | 35 | |||
| 54916 | 184619 | DPW Maintained 1 | :: 45 | 3000x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5984675.7685 | 2102938.8014 | 37.7533828605842 | -122.495930852185 | (37.7533828605842, -122.495930852185) | 1 | 8 | 3 | 56 | 35 | |||
| 57150 | 10247 | DPW Maintained 1 | :: 45 | 112 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/1997 12:00:00 AM | 8 | 3X3 | 6005536.2501 | 2109637.4907 | 37.7729755585516 | -122.424267236647 | (37.7729755585516, -122.424267236647) | 7 | 9 | 11 | 28852 | 10 | ||
| 57503 | 115068 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 66707 | 244491 | DPW Maintained 1 | :: 45 | 442 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/28/2011 12:00:00 AM | 2 | Width 0ft | 6004006.3051 | 2109418.5142 | 37.7722877948852 | -122.429543882592 | (37.7722877948852, -122.429543882592) | 7 | 9 | 11 | 29492 | 10 | ||
| 69404 | 244492 | DPW Maintained 1 | :: 45 | 456 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/02/2009 12:00:00 AM | 2 | Width 0ft | 6003951.2344 | 2109410.9782 | 37.7722639846023 | -122.429733839468 | (37.7722639846023, -122.429733839468) | 7 | 9 | 11 | 29492 | 10 | ||
| 72393 | 29881 | DPW Maintained 1 | :: 45 | 270 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6006056.28059 | 2108026.10587 | 37.7685804313738 | -122.42235387246 | (37.7685804313738, -122.42235387246) | 8 | 4 | 5 | 28853 | 19 | |||
| 80835 | 10233 | DPW Maintained 1 | :: 45 | 20 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005984.609 | 2109698.904 | 37.77316949126 | -122.422720671561 | (37.77316949126, -122.422720671561) | 7 | 9 | 11 | 28852 | 10 | |||
| 82350 | 7876 | DPW Maintained 1 | :: 45 | 1095X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/04/2011 12:00:00 AM | 3 | 3x3 | 6006012.62101 | 2113826.37447 | 37.7845041008944 | -122.422917178661 | (37.7845041008944, -122.422917178661) | 7 | 9 | 11 | 28858 | 41 | ||
| 95197 | 10300 | DPW Maintained 1 | :: 45 | 548 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6003485.1293 | 2109346.6257 | 37.772060883831 | -122.43134154303 | (37.772060883831, -122.43134154303) | 15 | 9 | 11 | 29492 | 10 | |||
| 95951 | 115061 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 107751 | 1635 | DPW Maintained 1 | :: 45 | 819 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/22/2014 12:00:00 AM | 3 | 4X4 | 5995645.06873 | 2110681.65476 | 37.775279084646 | -122.458557415767 | (37.775279084646, -122.458557415767) | 11 | 6 | 2 | 54 | 11 | ||
| 108361 | 184627 | DPW Maintained 1 | :: 45 | 3300x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5983533.5949 | 2102898.8676 | 37.7532062522999 | -122.499877713808 | (37.7532062522999, -122.499877713808) | 1 | 8 | 3 | 56 | 35 | |||
| 113400 | 10343 | DPW Maintained 1 | :: 45 | 940 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6001599.8151 | 2109085.1313 | 37.7712358586189 | -122.437844249148 | (37.7712358586189, -122.437844249148) | 15 | 5 | 11 | 29492 | 9 | |||
| 113799 | 228442 | DPW Maintained 1 | :: 45 | 413 Haight St | 1 | : | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 5 | Width 3ft | 6004129.64861 | 2109389.34953 | 37.7722146987825 | -122.429115146464 | (37.7722146987825, -122.429115146464) | 7 | 9 | 11 | 29492 | 10 | ||
| 115561 | 115066 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 115574 | 15276 | DPW Maintained 1 | :: 45 | 1563X Mission St | 1 | Median : Cutout | Tree | DPW 1 | 10/28/2016 12:00:00 AM | 3 | Permit Number 777705 | 6007259.77782 | 2109715.95764 | 37.7732881790271 | -122.418310894637 | (37.7732881790271, -122.418310894637) | 8 | 2 | 9 | 28853 | 19 | ||
| 120746 | 28868 | DPW Maintained 1 | :: 45 | 75 01st St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6013233.2298598 | 2115774.102568 | 37.7902568901803 | -122.398072854346 | (37.7902568901803, -122.398072854346) | 12 | 2 | 9 | 28855 | 6 | ||
| 124917 | 252845 | DPW Maintained 1 | :: 45 | 544 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2014 12:00:00 AM | 3x3 | 5993963 | 2110797 | 37.7754989773977 | -122.464384407684 | (37.7754989773977, -122.464384407684) | 11 | 6 | 2 | 54 | 11 | |||
| 126828 | 139746 | DPW Maintained 1 | :: 45 | 1314 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/03/2013 12:00:00 AM | 2 | Width 0ft | 6004648.3504 | 2113539.1351 | 37.783638338735 | -122.427616619318 | (37.783638338735, -122.427616619318) | 7 | 9 | 11 | 28858 | 41 | ||
| 129732 | 228443 | DPW Maintained 1 | :: 45 | 401 Haight St | 1 | : | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 5 | Width 3ft | 6004157.65728 | 2109393.74469 | 37.7722283522845 | -122.429018575473 | (37.7722283522845, -122.429018575473) | 7 | 9 | 11 | 29492 | 10 | ||
| 130099 | 6759 | DPW Maintained 1 | :: 45 | 1275 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2015 12:51:00 PM | 3 | 3x3 | 6017200.09768 | 2096971.16598 | 37.7388481798969 | -122.383038438091 | (37.7388481798969, -122.383038438091) | 10 | 3 | 8 | 58 | 1 | ||
| 133535 | 184618 | DPW Maintained 1 | :: 45 | 3900x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5981674.4395 | 2102837.4254 | 37.7529282714167 | -122.506302380507 | (37.7529282714167, -122.506302380507) | 1 | 8 | 3 | 56 | 35 | |||
| 138927 | 10288 | DPW Maintained 1 | :: 45 | 447 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6003998.90174 | 2109366.95645 | 37.7721458107158 | -122.429565813827 | (37.7721458107158, -122.429565813827) | 7 | 9 | 11 | 29492 | 10 | ||
| 147088 | 24920 | DPW Maintained 1 | :: 45 | 430 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6004056.545 | 2109425.8569 | 37.7723108006121 | -122.429370621982 | (37.7723108006121, -122.429370621982) | 7 | 9 | 11 | 29492 | 10 | |||
| 148974 | 228437 | DPW Maintained 1 | :: 45 | 160 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 6 | Width 3ft | 6004091.19769 | 2108012.29591 | 37.7684314676748 | -122.429149946611 | (37.7684314676748, -122.429149946611) | 7 | 9 | 5 | 28862 | 3 | ||
| 149955 | 106460 | Undocumented 4 | :: 45 | 701 Cortland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6007932 | 2097222.5 | 37.7390218122591 | -122.415101080128 | (37.7390218122591, -122.415101080128) | 2 | 7 | 7 | 28859 | 2 | |||||
| 150847 | 115065 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 152782 | 104960 | Permitted Site 7 | :: 45 | 2895 San Bruno Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6011715.1 | 2091289.8 | 37.7229437265236 | -122.401603910944 | (37.7229437265236, -122.401603910944) | 10 | 3 | 7 | 309 | 28 | ||||||
| 154502 | 115069 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 159590 | 106461 | Undocumented 4 | :: 45 | 701 Cortland Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6007932 | 2097222.5 | 37.7390218122591 | -122.415101080128 | (37.7390218122591, -122.415101080128) | 2 | 7 | 7 | 28859 | 2 | |||||
| 160788 | 228440 | DPW Maintained 1 | :: 45 | 451 Haight St | 1 | : | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 4 | Width 3ft | 6003980.50091 | 2109366.20592 | 37.7721427080557 | -122.429629410284 | (37.7721427080557, -122.429629410284) | 7 | 9 | 11 | 29492 | 10 | ||
| 162453 | 115062 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 167367 | 184611 | DPW Maintained 1 | :: 45 | 3800x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5982199.0286 | 2102854.3652 | 37.7530056532342 | -122.504489538097 | (37.7530056532342, -122.504489538097) | 1 | 8 | 3 | 56 | 35 | |||
| 177789 | 115063 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 182182 | 115064 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
| 185827 | 10354 | DPW Maintained 1 | :: 45 | 1016 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2000 12:00:00 AM | 20 | 3X3 | 6001244.7283 | 2109040.2146 | 37.7710923306016 | -122.439069286514 | (37.7710923306016, -122.439069286514) | 15 | 5 | 11 | 29492 | 9 | ||
| 188269 | 244494 | DPW Maintained 1 | :: 45 | 400 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 5 | Width 0ft | 6004177.5073 | 2109444.407 | 37.7723685822151 | -122.428953525151 | (37.7723685822151, -122.428953525151) | 7 | 9 | 11 | 29492 | 10 | ||
| 191423 | 6842 | DPW Maintained 1 | :: 45 | 1461 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/2016 07:14:00 AM | 3 | 3X3 | 6016194.23735 | 2097718.16262 | 37.7408436496142 | -122.386568339179 | (37.7408436496142, -122.386568339179) | 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) );