trees
99 rows where qSpecies_id = 259
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3408 | 176866 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 205 Seneca Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5999819.10608 | 2090379.3923 | 37.7197729711124 | -122.442660448227 | (37.7197729711124, -122.442660448227) | 9 | 7 | 6 | 28861 | 25 | |||
| 3928 | 206971 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 395 Faxon Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5994732.68246 | 2091163.36914 | 37.7216343177559 | -122.46029906557 | (37.7216343177559, -122.46029906557) | 9 | 8 | 6 | 28861 | 24 | |||
| 10770 | 206966 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 701 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5994703.93987 | 2091218.52457 | 37.7217841079442 | -122.460402414748 | (37.7217841079442, -122.460402414748) | 9 | 8 | 6 | 28861 | 24 | |||
| 20978 | 227063 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 310 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008808.10283 | 2097327.49228 | 37.739359293383 | -122.412079324914 | (37.739359293383, -122.412079324914) | 10 | 7 | 7 | 28859 | 2 | |||
| 24754 | 39986 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1418 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/1999 12:00:00 AM | 18 | 3x3 | Permit Number 41244 | 6017089.67388 | 2093785.22875 | 37.7300941278447 | -122.383198540784 | (37.7300941278447, -122.383198540784) | 10 | 3 | 8 | 58 | 1 |
| 27620 | 227067 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 880 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004324.42611 | 2103760.82599 | 37.7567711466818 | -122.428040225476 | (37.7567711466818, -122.428040225476) | 2 | 4 | 5 | 28862 | 3 | |||
| 28103 | 65848 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 60 Rico Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1990 12:00:00 AM | 9 | Permit Number 28839 | 6001380.15928 | 2121427.38257 | 37.8051120044819 | -122.439488941356 | (37.8051120044819, -122.439488941356) | 13 | 9 | 1 | 57 | 17 | |
| 28510 | 227060 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1590 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6003308.34856 | 2098978.33105 | 37.7435820007231 | -122.431212834906 | (37.7435820007231, -122.431212834906) | 2 | 7 | 5 | 63 | 22 | |||
| 31478 | 227054 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 16 Lapidge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005981.42855 | 2105394.22422 | 37.7613496842601 | -122.422425749859 | (37.7613496842601, -122.422425749859) | 2 | 4 | 5 | 28859 | 19 | |||
| 31569 | 108824 | Permitted Site 7 | Lagerstroemia indica :: Crape Myrtle 259 | 146-150X Gillette Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6013072.89275 | 2086799.91674 | 37.7106910734067 | -122.39659568235 | (37.7106910734067, -122.39659568235) | 10 | 3 | 8 | 309 | 1 | |
| 31957 | 129364 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 950 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006675.50355 | 2113954.04144 | 37.784892024402 | -122.420632892917 | (37.784892024402, -122.420632892917) | 13 | 9 | 9 | 28858 | 36 | |||
| 33528 | 97783 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1616 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 56445 | 6013126.61766 | 2104759.99043 | 37.7600086979704 | -122.397668881632 | (37.7600086979704, -122.397668881632) | 10 | 3 | 8 | 28856 | 29 | |
| 40256 | 227071 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 3600 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004281.06062 | 2103673.66097 | 37.7565293585559 | -122.428183987515 | (37.7565293585559, -122.428183987515) | 2 | 4 | 5 | 28862 | 3 | |||
| 45279 | 176870 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 466 Paris St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6001967.43122 | 2090909.78134 | 37.721351533129 | -122.435272376418 | (37.721351533129, -122.435272376418) | 9 | 7 | 6 | 28861 | 5 | |||
| 53049 | 227050 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 295 Buchanan St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6004692.50509 | 2109376.85027 | 37.7722122247492 | -122.42716728596 | (37.7722122247492, -122.42716728596) | 7 | 9 | 11 | 28852 | 10 | |||
| 53089 | 30 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 750 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 1X1 | 6003777.42436 | 2107761.72523 | 37.7677256941011 | -122.430217381651 | (37.7677256941011, -122.430217381651) | 7 | 9 | 5 | 28862 | 3 | |||
| 56178 | 217761 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 460 West Portal Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5991726.04685 | 2096477.62924 | 37.7360525419872 | -122.471079064459 | (37.7360525419872, -122.471079064459) | 1 | 8 | 4 | 29491 | 40 | |||
| 56467 | 227072 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 3600 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004257.64843 | 2103674.51976 | 37.75653039189 | -122.428265016426 | (37.75653039189, -122.428265016426) | 2 | 4 | 5 | 28862 | 3 | |||
| 60129 | 97782 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1616 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2010 12:00:00 AM | 2 | 3x3 | Permit Number 56445 | 6013154.51165 | 2104761.54844 | 37.7600145291653 | -122.397572518371 | (37.7600145291653, -122.397572518371) | 10 | 3 | 8 | 28856 | 29 | |
| 61193 | 227065 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 278 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002058.8176 | 2104239.30428 | 37.7579564927083 | -122.43590975565 | (37.7579564927083, -122.43590975565) | 2 | 4 | 5 | 28862 | 3 | |||
| 61358 | 97440 | Permitted Site 7 | Lagerstroemia indica :: Crape Myrtle 259 | 1900 Pacific Ave | 5 | Front Yard : Yard | Tree | Private 2 | 10/11/2011 12:00:00 AM | Permit Number 768364 | 6004943.9 | 2117474.7 | 37.7944611255838 | -122.426874507837 | (37.7944611255838, -122.426874507837) | 13 | 9 | 1 | 28858 | 27 | |||
| 62094 | 227069 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 880 Church St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004326.63425 | 2103721.26686 | 37.7566626515725 | -122.42802976997 | (37.7566626515725, -122.42802976997) | 2 | 4 | 5 | 28862 | 3 | |||
| 63094 | 206968 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 395 Faxon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5994733.59655 | 2091193.22902 | 37.7217163584134 | -122.460298068196 | (37.7217163584134, -122.460298068196) | 9 | 8 | 6 | 28861 | 24 | |||
| 64564 | 227068 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 880 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004327.06054 | 2103741.95573 | 37.7567194824462 | -122.428029769971 | (37.7567194824462, -122.428029769971) | 2 | 4 | 5 | 28862 | 3 | |||
| 67389 | 206975 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1050 Plymouth Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5995957.75422 | 2090863.30399 | 37.7208808036758 | -122.456042662447 | (37.7208808036758, -122.456042662447) | 9 | 8 | 6 | 28861 | 24 | |||
| 74951 | 227074 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 22 Whitney St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6004252.81096 | 2098130.67002 | 37.7413079947792 | -122.427886727413 | (37.7413079947792, -122.427886727413) | 2 | 7 | 5 | 63 | 7 | |||
| 75147 | 176871 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 466 Paris St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 6001962.84798 | 2090902.89386 | 37.7213323613752 | -122.435287726964 | (37.7213323613752, -122.435287726964) | 9 | 7 | 6 | 28861 | 5 | |||
| 76399 | 69350 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 3445 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 1 | Permit Number 33441 | 6002188.20327 | 2120049.04507 | 37.8013734076063 | -122.43659389422 | (37.8013734076063, -122.43659389422) | 13 | 9 | 1 | 57 | 17 | |
| 79154 | 176868 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 466 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 6001976.13517 | 2090923.79874 | 37.7213905160501 | -122.435243291469 | (37.7213905160501, -122.435243291469) | 9 | 7 | 6 | 28861 | 5 | |||
| 82182 | 191217 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 2 Bridgeview Dr | 3 | Front Yard : Yard | Tree | Private 2 | 3 | 6014080.31435 | 2095351.02168 | 37.7342267167801 | -122.393711908685 | (37.7342267167801, -122.393711908685) | 10 | 3 | 8 | 58 | 1 | ||||
| 84032 | 258479 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 80 Dichiera Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5998566.29987 | 2087993.98473 | 37.7131516918716 | -122.446819386407 | (37.7131516918716, -122.446819386407) | 9 | 7 | 6 | 28861 | 25 | |||||
| 84277 | 227075 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1720 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003949.62803 | 2098226.14791 | 37.7415529988693 | -122.428941832723 | (37.7415529988693, -122.428941832723) | 2 | 7 | 5 | 63 | 7 | |||
| 85826 | 120763 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1914 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5989528.9744 | 2113375.12093 | 37.7823211945019 | -122.479911294439 | (37.7823211945019, -122.479911294439) | 11 | 6 | 2 | 55 | 26 | |||
| 90003 | 206982 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 425 Dewey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5995074.1246 | 2100289.40208 | 37.7467118060141 | -122.459779506518 | (37.7467118060141, -122.459779506518) | 1 | 8 | 4 | 59 | 40 | |||
| 94729 | 217760 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 460 West Portal Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5991734.77197 | 2096495.43616 | 37.7361019399402 | -122.471050195332 | (37.7361019399402, -122.471050195332) | 1 | 8 | 4 | 29491 | 40 | |||
| 95887 | 206978 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 323 Tara St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5997663.37631 | 2090063.53352 | 37.7187825720371 | -122.450089254831 | (37.7187825720371, -122.450089254831) | 9 | 8 | 6 | 28861 | 24 | |||
| 98955 | 86184 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1707 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988709.6107 | 2103691.4443 | 37.7556848454942 | -122.482036276815 | (37.7556848454942, -122.482036276815) | 1 | 8 | 3 | 56 | 35 | ||
| 101098 | 68287 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 92 Diana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/1993 12:00:00 AM | 8 | Permit Number 32096 | 6013263.65718 | 2093846.48043 | 37.7300501410779 | -122.396429949508 | (37.7300501410779, -122.396429949508) | 10 | 3 | 8 | 58 | 1 | ||
| 101541 | 129363 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 2936 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001041.88573 | 2118458.11971 | 37.7969399387778 | -122.440446486433 | (37.7969399387778, -122.440446486433) | 13 | 9 | 1 | 57 | 17 | |||
| 102770 | 206969 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 395 Faxon Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5994733.36792 | 2091182.31621 | 37.7216863813004 | -122.460298068228 | (37.7216863813004, -122.460298068228) | 9 | 8 | 6 | 28861 | 24 | |||
| 103374 | 206972 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 395 Faxon Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5994732.3997 | 2091149.87194 | 37.721597241413 | -122.460299065558 | (37.721597241413, -122.460299065558) | 9 | 8 | 6 | 28861 | 24 | |||
| 103905 | 227061 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 800 Alvarado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001153.32167 | 2102624.46205 | 37.7534710466702 | -122.438925612327 | (37.7534710466702, -122.438925612327) | 2 | 4 | 5 | 28862 | 22 | |||
| 106012 | 191214 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 536 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011191.48896 | 2105828.96984 | 37.7628359281474 | -122.404436841187 | (37.7628359281474, -122.404436841187) | 8 | 3 | 8 | 28856 | 29 | |||
| 106062 | 129370 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 315 Beach St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6008475.09899 | 2122066.50156 | 37.8072680931263 | -122.414981246496 | (37.8072680931263, -122.414981246496) | 3 | 1 | 10 | 308 | 23 | |||
| 107068 | 105891 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1100 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2014 12:00:00 AM | Permit Number 771559 | 5999444.5 | 2109060.1 | 37.7710443339737 | -122.445297745357 | (37.7710443339737, -122.445297745357) | 15 | 5 | 11 | 29492 | 9 | |||
| 108500 | 206963 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 452 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 5997448.90229 | 2097287.52681 | 37.7386056696229 | -122.451351336401 | (37.7386056696229, -122.451351336401) | 9 | 7 | 4 | 59 | 40 | |||
| 110746 | 227052 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 16 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005980.22404 | 2105419.01454 | 37.7614176847105 | -122.422431677274 | (37.7614176847105, -122.422431677274) | 2 | 4 | 5 | 28859 | 19 | |||
| 113980 | 123556 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 101 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994248.60901 | 2114775.00999 | 37.7864379805878 | -122.46368520872 | (37.7864379805878, -122.46368520872) | 11 | 6 | 1 | 54 | 11 | |||
| 114461 | 97784 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1616 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 56445 | 6013108.29452 | 2104759.94279 | 37.760007546818 | -122.397732249637 | (37.760007546818, -122.397732249637) | 10 | 3 | 8 | 28856 | 29 | |
| 114743 | 123555 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 101 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994248.76997 | 2114782.67993 | 37.7864590494309 | -122.463685208724 | (37.7864590494309, -122.463685208724) | 11 | 6 | 1 | 54 | 11 | |||
| 123812 | 206983 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 495 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 10ft | 5998187.12093 | 2095228.03706 | 37.7329930456965 | -122.448650649802 | (37.7329930456965, -122.448650649802) | 9 | 7 | 4 | 59 | 40 | |||
| 124464 | 191215 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 695 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 6012749.19171 | 2104260.69013 | 37.7586167048125 | -122.398939180317 | (37.7586167048125, -122.398939180317) | 10 | 3 | 8 | 28856 | 29 | |||
| 126833 | 176867 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 692 London St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000958.88586 | 2089823.00585 | 37.7183101671468 | -122.438680794379 | (37.7183101671468, -122.438680794379) | 9 | 7 | 6 | 28861 | 5 | |||
| 129298 | 206970 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 395 Faxon Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5994732.76669 | 2091167.38946 | 37.7216453614367 | -122.460299065552 | (37.7216453614367, -122.460299065552) | 9 | 8 | 6 | 28861 | 24 | |||
| 130005 | 129368 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 315 Beach St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6008451.96594 | 2122064.5899 | 37.8072615442584 | -122.415061168339 | (37.8072615442584, -122.415061168339) | 3 | 1 | 10 | 308 | 23 | |||
| 130194 | 227053 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 16 Lapidge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005980.85073 | 2105411.52348 | 37.7613971513711 | -122.422428977523 | (37.7613971513711, -122.422428977523) | 2 | 4 | 5 | 28859 | 19 | |||
| 135399 | 206974 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 146 Miramar Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 5995372.5326 | 2090893.02232 | 37.7209287951196 | -122.458067733342 | (37.7209287951196, -122.458067733342) | 9 | 8 | 6 | 28861 | 24 | |||
| 135606 | 206967 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 701 Holloway Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5994707.06949 | 2091218.52811 | 37.7217842976985 | -122.460391596797 | (37.7217842976985, -122.460391596797) | 9 | 8 | 6 | 28861 | 24 | |||
| 135956 | 227064 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 4441 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001211.68109 | 2104631.03803 | 37.7589839384659 | -122.438867577298 | (37.7589839384659, -122.438867577298) | 2 | 4 | 5 | 28862 | 3 | |||
| 137901 | 201361 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 225 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 2ft | 6013041.33854 | 2092709.54059 | 37.726915962381 | -122.397118848181 | (37.726915962381, -122.397118848181) | 10 | 3 | 8 | 58 | 1 | |||
| 138491 | 227066 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 880 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004322.18511 | 2103780.44049 | 37.7568248766824 | -122.428049373404 | (37.7568248766824, -122.428049373404) | 2 | 4 | 5 | 28862 | 3 | |||
| 139529 | 227070 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 3600 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004299.63219 | 2103676.28895 | 37.7565376251397 | -122.428119947672 | (37.7565376251397, -122.428119947672) | 2 | 4 | 5 | 28862 | 3 | |||
| 139793 | 121613 | Undocumented 4 | Lagerstroemia indica :: Crape Myrtle 259 | 800X Alvarado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001168 | 2102650 | 37.7535420028484 | -122.438876681597 | (37.7535420028484, -122.438876681597) | 2 | 4 | 5 | 28862 | 22 | ||||
| 140037 | 206965 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 428 Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/2009 12:00:00 AM | 1 | Width 2ft | Permit Number 52108 | 5997891.77547 | 2094116.71223 | 37.7299247189373 | -122.449591679718 | (37.7299247189373, -122.449591679718) | 9 | 7 | 4 | 28861 | 40 | |
| 140839 | 42951 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 454 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | 2 | Permit Number 42844 | 6010612.89233 | 2106188.01091 | 37.7637894226584 | -122.406463315032 | (37.7637894226584, -122.406463315032) | 8 | 4 | 8 | 28859 | 19 | |
| 141373 | 227062 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 884 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6000725.1637 | 2102600.6737 | 37.7533813599857 | -122.440404564513 | (37.7533813599857, -122.440404564513) | 2 | 4 | 5 | 28862 | 22 | |||
| 142199 | 11460 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 10 Jakey Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2013 12:00:00 AM | 6 | 3X3 | 6016801.30429 | 2095509.33551 | 37.7348122428792 | -122.384315510452 | (37.7348122428792, -122.384315510452) | 10 | 3 | 8 | 58 | 1 | ||
| 142694 | 129365 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 950 O'Farrell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006602.548 | 2113943.17336 | 37.7848580713737 | -122.420884524127 | (37.7848580713737, -122.420884524127) | 13 | 9 | 9 | 28858 | 36 | |||
| 144443 | 186854 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 2700 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985211.9517 | 2096276.1566 | 37.7351204295726 | -122.493585753219 | (37.7351204295726, -122.493585753219) | 1 | 8 | 3 | 29491 | 35 | |||
| 144637 | 227051 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 2770 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009518.98331 | 2103379.95882 | 37.7560178907361 | -122.410048575691 | (37.7560178907361, -122.410048575691) | 2 | 4 | 7 | 28859 | 19 | |||
| 146841 | 206976 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 758 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994474.73977 | 2089943.06008 | 37.7182688001342 | -122.461102290543 | (37.7182688001342, -122.461102290543) | 9 | 8 | 6 | 28861 | 24 | |||
| 147173 | 199667 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1903 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015175.9259 | 2093373.705 | 37.7288582250507 | -122.389785932946 | (37.7288582250507, -122.389785932946) | 10 | 3 | 8 | 58 | 1 | |||
| 149048 | 206973 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 395 Faxon Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5994731.32919 | 2091112.54533 | 37.721494689904 | -122.460300062907 | (37.721494689904, -122.460300062907) | 9 | 8 | 6 | 28861 | 24 | |||
| 152056 | 176873 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 34 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008389.4363 | 2086207.95793 | 37.7088039104301 | -122.412740993025 | (37.7088039104301, -122.412740993025) | 9 | 7 | 8 | 309 | 39 | |||
| 153928 | 227057 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 36 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006024.56272 | 2102894.52743 | 37.7544885324337 | -122.422098977597 | (37.7544885324337, -122.422098977597) | 2 | 4 | 5 | 28859 | 19 | |||
| 154832 | 139627 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1911 EDDY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001197.3517 | 2112443.2085 | 37.7804333986461 | -122.439477144015 | (37.7804333986461, -122.439477144015) | 15 | 5 | 11 | 29490 | 41 | |||
| 159599 | 143013 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 460 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/2015 12:00:00 AM | 7 | Width 0ft | 6010152.8638 | 2120618.4108 | 37.8033861308221 | -122.409072703167 | (37.8033861308221, -122.409072703167) | 3 | 1 | 10 | 308 | 23 | ||
| 165162 | 206981 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 425 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5995081.28449 | 2100295.43266 | 37.7467287762207 | -122.459755185252 | (37.7467287762207, -122.459755185252) | 1 | 8 | 4 | 59 | 40 | |||
| 166477 | 176869 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 466 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 1ft | 6001971.78547 | 2090916.90643 | 37.7213713443005 | -122.435257834404 | (37.7213713443005, -122.435257834404) | 9 | 7 | 6 | 28861 | 5 | |||
| 167322 | 227059 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 675 28th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6001568.11505 | 2099383.94342 | 37.7445969450103 | -122.437259159597 | (37.7445969450103, -122.437259159597) | 2 | 7 | 5 | 63 | 22 | |||
| 167372 | 227056 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 643 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009797.85422 | 2100427.87746 | 37.7479277577665 | -122.408875872347 | (37.7479277577665, -122.408875872347) | 2 | 7 | 7 | 28859 | 2 | |||
| 170385 | 129371 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 315 Beach St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6008483.18114 | 2122068.5506 | 37.8072741734254 | -122.414953421476 | (37.8072741734254, -122.414953421476) | 3 | 1 | 10 | 308 | 23 | |||
| 170618 | 27166 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1950 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/16/1999 12:00:00 AM | 5 | 2X3 | 6011856.11621 | 2095630.9787 | 37.7348715720666 | -122.401421384693 | (37.7348715720666, -122.401421384693) | 10 | 3 | 8 | 58 | 1 | ||
| 170832 | 129366 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1515 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007909.93455 | 2117647.30937 | 37.7951023261634 | -122.416623869891 | (37.7951023261634, -122.416623869891) | 5 | 1 | 10 | 28858 | 32 | |||
| 171715 | 206977 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1x Minerva St | 19 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 5996177.78414 | 2089001.83186 | 37.7157822655174 | -122.455147642762 | (37.7157822655174, -122.455147642762) | 9 | 8 | 6 | 28861 | 24 | |||
| 172929 | 227055 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1523 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009607.86585 | 2100388.33634 | 37.7478085427258 | -122.409530056269 | (37.7478085427258, -122.409530056269) | 2 | 7 | 7 | 28859 | 2 | |||
| 173638 | 13033 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 468 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6010099.3086 | 2120611.2701 | 37.8033635239583 | -122.409257529603 | (37.8033635239583, -122.409257529603) | 3 | 1 | 10 | 308 | 23 | |||
| 174558 | 186879 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 2700 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985177.7993 | 2096457.4623 | 37.7356162487584 | -122.493717184531 | (37.7356162487584, -122.493717184531) | 1 | 8 | 3 | 29491 | 35 | |||
| 174582 | 206979 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 323 Tara St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5997666.46898 | 2090072.17024 | 37.718806463439 | -122.45007918692 | (37.718806463439, -122.45007918692) | 9 | 8 | 6 | 28861 | 24 | |||
| 178029 | 206980 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 401 Victoria St | 10 | : | Tree | Private 2 | 4 | Width 2ft | 5993229.06721 | 2089889.63309 | 37.7180503395402 | -122.465404139084 | (37.7180503395402, -122.465404139084) | 9 | 8 | 6 | 64 | 24 | |||
| 178852 | 55612 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 620 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1973 12:00:00 AM | 5 | Permit Number 11589 | 6008867.71291 | 2091224.31143 | 37.7226046106923 | -122.411442154341 | (37.7226046106923, -122.411442154341) | 9 | 3 | 7 | 309 | 28 | ||
| 179185 | 227073 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 110 Henry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002808.43426 | 2107410.93837 | 37.7667075878083 | -122.433543924419 | (37.7667075878083, -122.433543924419) | 15 | 5 | 5 | 28862 | 3 | |||
| 180084 | 227058 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 267 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006192.47769 | 2101670.77232 | 37.7511378518545 | -122.421431380271 | (37.7511378518545, -122.421431380271) | 2 | 4 | 5 | 28859 | 19 | |||
| 182437 | 129367 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 1515 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007911.49286 | 2117626.11429 | 37.795044217366 | -122.41661697571 | (37.795044217366, -122.41661697571) | 5 | 1 | 10 | 28858 | 32 | |||
| 182942 | 206964 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 481 Flood Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997573.15769 | 2094088.10013 | 37.7298279240054 | -122.450691111732 | (37.7298279240054, -122.450691111732) | 9 | 7 | 4 | 28861 | 40 | |||
| 184833 | 250984 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 165 Seal Rock Dr | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5981096.44332 | 2112928.00583 | 37.7806000288029 | -122.509050381992 | (37.7806000288029, -122.509050381992) | 11 | 6 | 2 | 55 | 26 | |||
| 192475 | 84291 | Permitted Site 7 | Lagerstroemia indica :: Crape Myrtle 259 | 36 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50593 | 6006036.40406363 | 2102899.92286598 | 37.7545040149209 | -122.422058410345 | (37.7545040149209, -122.422058410345) | 2 | 4 | 5 | 28859 | 19 | ||
| 193349 | 129369 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 315 Beach St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6008462.41761 | 2122065.39822 | 37.807264351026 | -122.415025055184 | (37.807264351026, -122.415025055184) | 3 | 1 | 10 | 308 | 23 | |||
| 194050 | 176872 | DPW Maintained 1 | Lagerstroemia indica :: Crape Myrtle 259 | 154 Gillette Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013005.3096 | 2086655.27968 | 37.7102901669233 | -122.39681913291 | (37.7102901669233, -122.39681913291) | 10 | 3 | 8 | 309 | 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) );