trees
1,377 rows where qSpecies_id = 61 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193951 | 142653 | DPW Maintained 1 | Tristania conferta :: 61 | 1188 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6007975.5818 | 2121216.8848 | 37.8049071789669 | -122.416649713579 | (37.8049071789669, -122.416649713579) | 5 | 1 | 10 | 308 | 23 | |||
193937 | 199710 | DPW Maintained 1 | Tristania conferta :: 61 | 1925 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016332.671 | 2092691.0173 | 37.7270477778667 | -122.38573938499 | (37.7270477778667, -122.38573938499) | 10 | 3 | 8 | 58 | 1 | |||
193522 | 13279 | DPW Maintained 1 | Tristania conferta :: 61 | 2525 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2008 12:00:00 AM | 6 | 3X3 | 6000265.7268 | 2119165.2172 | 37.7988372159853 | -122.443182983285 | (37.7988372159853, -122.443182983285) | 13 | 9 | 1 | 57 | 17 | ||
193464 | 200665 | DPW Maintained 1 | Tristania conferta :: 61 | 1597 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6015266.0623 | 2095626.5656 | 37.7350491243576 | -122.389631603317 | (37.7350491243576, -122.389631603317) | 10 | 3 | 8 | 58 | 1 | |||
193240 | 143432 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010753.9601 | 2116917.9148 | 37.7932591248157 | -122.406731631165 | (37.7932591248157, -122.406731631165) | 3 | 1 | 10 | 28857 | 4 | |||
193071 | 10456 | DPW Maintained 1 | Tristania conferta :: 61 | 1556 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5998680.607 | 2108678.296 | 37.7699523629106 | -122.447912571831 | (37.7699523629106, -122.447912571831) | 15 | 5 | 11 | 29492 | 9 | |||
192938 | 7064 | DPW Maintained 1 | Tristania conferta :: 61 | 1564 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5999951.2096 | 2109897.9532 | 37.7733737782492 | -122.443605224711 | (37.7733737782492, -122.443605224711) | 15 | 5 | 11 | 29492 | 16 | |||
192834 | 201884 | DPW Maintained 1 | Tristania conferta :: 61 | 199 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015227.9296 | 2115567.3435 | 37.7898000735545 | -122.391156824011 | (37.7898000735545, -122.391156824011) | 6 | 2 | 9 | 28855 | 6 | |||
192325 | 138909 | DPW Maintained 1 | Tristania conferta :: 61 | 727 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004219.3061 | 2110788.4288 | 37.776061302871 | -122.428904776437 | (37.776061302871, -122.428904776437) | 7 | 9 | 11 | 28852 | 10 | |||
192212 | 200894 | DPW Maintained 1 | Tristania conferta :: 61 | 4245 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6015439.658 | 2097003.1217 | 37.7388384915964 | -122.389127500827 | (37.7388384915964, -122.389127500827) | 10 | 3 | 8 | 58 | 1 | |||
192112 | 200179 | DPW Maintained 1 | Tristania conferta :: 61 | 3224 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6014060.5679 | 2089717.7254 | 37.7187577226119 | -122.393386087342 | (37.7187577226119, -122.393386087342) | 10 | 3 | 8 | 58 | 1 | |||
192100 | 29386 | DPW Maintained 1 | Tristania conferta :: 61 | 3199X Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014271.9163 | 2089934.5554 | 37.7193648351704 | -122.392670694873 | (37.7193648351704, -122.392670694873) | 10 | 3 | 8 | 58 | 1 | ||
191925 | 2173 | DPW Maintained 1 | Tristania conferta :: 61 | 1010X Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6001288.5645 | 2109046.8136 | 37.7711129439788 | -122.438918128915 | (37.7711129439788, -122.438918128915) | 15 | 5 | 11 | 29492 | 9 | |||
191857 | 199797 | DPW Maintained 1 | Tristania conferta :: 61 | 2655 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015107.7412 | 2091052.6667 | 37.7224813341695 | -122.389859594082 | (37.7224813341695, -122.389859594082) | 10 | 3 | 8 | 58 | 1 | |||
191788 | 141089 | DPW Maintained 1 | Tristania conferta :: 61 | 100x JORDAN AVE | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 5996248.2713 | 2112978.5918 | 37.7816205163369 | -122.456636959709 | (37.7816205163369, -122.456636959709) | 11 | 6 | 1 | 54 | 31 | |||
191649 | 22379 | DPW Maintained 1 | Tristania conferta :: 61 | 5545 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/2007 12:00:00 AM | 3 | 3x3 | 6014134.9775 | 2092764.4635 | 37.7271275910824 | -122.39334197422 | (37.7271275910824, -122.39334197422) | 10 | 3 | 8 | 58 | 1 | ||
191358 | 199929 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016487.4596 | 2092903.0942 | 37.727638663365 | -122.385219049049 | (37.727638663365, -122.385219049049) | 10 | 3 | 8 | 58 | 1 | ||
191353 | 246001 | DPW Maintained 1 | Tristania conferta :: 61 | 1437 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/2007 12:00:00 AM | 3 | Width 0ft | 5999214.6581 | 2108701.4088 | 37.7700463362513 | -122.446066968815 | (37.7700463362513, -122.446066968815) | 15 | 5 | 11 | 29492 | 9 | ||
191309 | 140352 | DPW Maintained 1 | Tristania conferta :: 61 | 1314 ELLIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004399.7686 | 2113290.1868 | 37.7829407248934 | -122.428458867439 | (37.7829407248934, -122.428458867439) | 7 | 9 | 11 | 29490 | 41 | |||
191173 | 13094 | DPW Maintained 1 | Tristania conferta :: 61 | 1450 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1995 12:00:00 AM | 12 | 3X3 | 6005349.3555 | 2119944.5969 | 37.801265750478 | -122.425647455227 | (37.801265750478, -122.425647455227) | 13 | 9 | 1 | 57 | 17 | ||
191127 | 24257 | DPW Maintained 1 | Tristania conferta :: 61 | 600X Willow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2004 12:00:00 AM | 5 | 3X3 | 6004635.8921 | 2113135.7984 | 37.782530171668 | -122.427630974469 | (37.782530171668, -122.427630974469) | 7 | 9 | 11 | 29490 | 41 | ||
191021 | 29566 | DPW Maintained 1 | Tristania conferta :: 61 | 3224 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 3 | 3x3 | 6014068.4858 | 2089729.2978 | 37.7187899380466 | -122.39335952752 | (37.7187899380466, -122.39335952752) | 10 | 3 | 8 | 58 | 1 | ||
190957 | 140043 | DPW Maintained 1 | Tristania conferta :: 61 | 910 SCOTT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001994.1202 | 2111638.8314 | 37.7782700950378 | -122.436663158472 | (37.7782700950378, -122.436663158472) | 15 | 5 | 11 | 29490 | 41 | |||
190930 | 141817 | DPW Maintained 1 | Tristania conferta :: 61 | 1286 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004361.0763 | 2112937.5471 | 37.78197027437 | -122.428567582168 | (37.78197027437, -122.428567582168) | 7 | 9 | 11 | 29490 | 41 | |||
190797 | 5892 | DPW Maintained 1 | Tristania conferta :: 61 | 1130 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6004999.3975 | 2113030.0107 | 37.7822602594178 | -122.426365868057 | (37.7822602594178, -122.426365868057) | 7 | 9 | 11 | 28858 | 41 | ||
190671 | 141173 | DPW Maintained 1 | Tristania conferta :: 61 | 1830 ELLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002027.3312 | 2112959.1326 | 37.7818971962022 | -122.436642800536 | (37.7818971962022, -122.436642800536) | 15 | 5 | 11 | 29490 | 41 | |||
190549 | 142045 | DPW Maintained 1 | Tristania conferta :: 61 | 375 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005919.394 | 2111002.5816 | 37.776745395276 | -122.423038937882 | (37.776745395276, -122.423038937882) | 7 | 9 | 11 | 28852 | 10 | |||
190547 | 257948 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
190391 | 17051 | DPW Maintained 1 | Tristania conferta :: 61 | 1235 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774567 | 6001055.3761 | 2109653.1693 | 37.7727645748724 | -122.43976821361 | (37.7727645748724, -122.43976821361) | 15 | 5 | 11 | 29492 | 9 | |
190370 | 5882 | DPW Maintained 1 | Tristania conferta :: 61 | 1112 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6005074.3413 | 2113041.8074 | 37.7822968862945 | -122.426107435817 | (37.7822968862945, -122.426107435817) | 7 | 9 | 11 | 28858 | 41 | ||
190258 | 245021 | DPW Maintained 1 | Tristania conferta :: 61 | 291 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001235.6925 | 2109653.6678 | 37.7727762056223 | -122.439144516103 | (37.7727762056223, -122.439144516103) | 15 | 5 | 11 | 29492 | 9 | |||
189986 | 141276 | DPW Maintained 1 | Tristania conferta :: 61 | 351 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998048.3369 | 2112566.7325 | 37.7805928446862 | -122.45037991932 | (37.7805928446862, -122.45037991932) | 15 | 6 | 2 | 54 | 16 | |||
189492 | 33674 | DPW Maintained 1 | Tristania conferta :: 61 | 672 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 4 | Permit Number 37756 | 6004147.6576 | 2110988.6622 | 37.7766070388542 | -122.429166908178 | (37.7766070388542, -122.429166908178) | 7 | 9 | 11 | 28852 | 10 | ||
189265 | 139673 | DPW Maintained 1 | Tristania conferta :: 61 | 2130 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001038.4554 | 2113169.8369 | 37.7824194905185 | -122.4400789585 | (37.7824194905185, -122.4400789585) | 15 | 5 | 11 | 29490 | 41 | |||
189258 | 142363 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005513.0496 | 2113400.4215 | 37.7833063379401 | -122.424615216414 | (37.7833063379401, -122.424615216414) | 7 | 9 | 11 | 28858 | 41 | |||
189100 | 246028 | DPW Maintained 1 | Tristania conferta :: 61 | 1350 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999255.0858 | 2108409.3301 | 37.7692466705714 | -122.445906120564 | (37.7692466705714, -122.445906120564) | 15 | 5 | 11 | 29492 | 9 | |||
188943 | 9758 | DPW Maintained 1 | Tristania conferta :: 61 | 735 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/25/1997 12:00:00 AM | 18 | 4x4 | 6005747.9577 | 2112242.2179 | 37.78013945886 | -122.423720149275 | (37.78013945886, -122.423720149275) | 7 | 9 | 11 | 28852 | 41 | ||
188787 | 244436 | DPW Maintained 1 | Tristania conferta :: 61 | 404 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004598.6589 | 2109671.3511 | 37.7730155449031 | -122.42751289272 | (37.7730155449031, -122.42751289272) | 7 | 9 | 11 | 28852 | 10 | |||
188720 | 13174 | DPW Maintained 1 | Tristania conferta :: 61 | 1950 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/1997 12:00:00 AM | 14 | 3X3 | 6003011.134 | 2119622.0359 | 37.8002476819942 | -122.43371565452 | (37.8002476819942, -122.43371565452) | 13 | 9 | 1 | 57 | 17 | ||
188671 | 139802 | DPW Maintained 1 | Tristania conferta :: 61 | 1101 GOUGH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005640.931 | 2113014.3973 | 37.7822536318566 | -122.42414533496 | (37.7822536318566, -122.42414533496) | 7 | 9 | 11 | 28852 | 41 | |||
188487 | 122837 | DPW Maintained 1 | Tristania conferta :: 61 | 945 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2x3 | 6001926.8941 | 2111799.4441 | 37.7787072764484 | -122.436907219039 | (37.7787072764484, -122.436907219039) | 15 | 5 | 11 | 29490 | 41 | |||
188253 | 246306 | DPW Maintained 1 | Tristania conferta :: 61 | 1601 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6007027.7234 | 2109258.4791 | 37.7720189866936 | -122.419081148892 | (37.7720189866936, -122.419081148892) | 8 | 2 | 9 | 28853 | 19 | |||
188008 | 6189 | DPW Maintained 1 | Tristania conferta :: 61 | 1100 Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005309.0043 | 2113417.5143 | 37.7833417448711 | -122.425322349467 | (37.7833417448711, -122.425322349467) | 7 | 9 | 11 | 28858 | 41 | |||
187806 | 6984 | DPW Maintained 1 | Tristania conferta :: 61 | 815 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2008 12:00:00 AM | 6 | 3X3 | 6003507.9341 | 2110337.394 | 37.7747825823251 | -122.431333396148 | (37.7747825823251, -122.431333396148) | 15 | 9 | 11 | 29492 | 10 | ||
187745 | 140524 | DPW Maintained 1 | Tristania conferta :: 61 | 1140 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003674.0233 | 2111802.6448 | 37.778815210032 | -122.430863450741 | (37.778815210032, -122.430863450741) | 15 | 9 | 11 | 29490 | 41 | |||
187699 | 5894 | DPW Maintained 1 | Tristania conferta :: 61 | 1142 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1992 12:00:00 AM | 3 | 3X3 | 6004948.741 | 2113023.7653 | 37.7822402475105 | -122.426540672216 | (37.7822402475105, -122.426540672216) | 7 | 9 | 11 | 28858 | 41 | ||
187605 | 257952 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
187577 | 22473 | DPW Maintained 1 | Tristania conferta :: 61 | 6237 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/1995 12:00:00 AM | 6 | 3x3 | 6013406.3289 | 2090861.7358 | 37.7218625753274 | -122.395727660172 | (37.7218625753274, -122.395727660172) | 10 | 3 | 8 | 58 | 1 | ||
187147 | 38128 | DPW Maintained 1 | Tristania conferta :: 61 | 2817 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 6 | Permit Number 40292 | 5986952.8937 | 2107070.8859 | 37.7648615361674 | -122.488359826673 | (37.7648615361674, -122.488359826673) | 1 | 8 | 3 | 56 | 35 | |
187085 | 142354 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005306.3187 | 2113367.185 | 37.7832034013247 | -122.425328057916 | (37.7832034013247, -122.425328057916) | 7 | 9 | 11 | 28858 | 41 | |||
186682 | 141193 | DPW Maintained 1 | Tristania conferta :: 61 | 1749 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002531.9181 | 2112976.3921 | 37.7819732483789 | -122.434898400244 | (37.7819732483789, -122.434898400244) | 15 | 5 | 11 | 29490 | 41 | |||
186475 | 142360 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005454.5534 | 2113392.4447 | 37.7832811318405 | -122.424817022557 | (37.7832811318405, -122.424817022557) | 7 | 9 | 11 | 28858 | 41 | |||
186310 | 143385 | DPW Maintained 1 | Tristania conferta :: 61 | 1658 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004429.3589 | 2119821.4466 | 37.8008755836208 | -122.428822263738 | (37.8008755836208, -122.428822263738) | 13 | 9 | 1 | 57 | 17 | |||
186231 | 140523 | DPW Maintained 1 | Tristania conferta :: 61 | 1110 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003749.9866 | 2111813.2797 | 37.7788487145301 | -122.430601422928 | (37.7788487145301, -122.430601422928) | 15 | 9 | 11 | 29490 | 41 | |||
186219 | 14467 | DPW Maintained 1 | Tristania conferta :: 61 | 211 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 55 | 2X3 | 5998904.0364 | 2112297.518 | 37.7799025871774 | -122.447400276043 | (37.7799025871774, -122.447400276043) | 15 | 5 | 2 | 54 | 16 | |||
186188 | 141269 | DPW Maintained 1 | Tristania conferta :: 61 | 399 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997767.7852 | 2112527.4756 | 37.7804689951324 | -122.451347644428 | (37.7804689951324, -122.451347644428) | 15 | 6 | 2 | 54 | 16 | |||
185972 | 141513 | DPW Maintained 1 | Tristania conferta :: 61 | 40 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 5998000.2419 | 2111479.5979 | 37.7776051034762 | -122.450467907345 | (37.7776051034762, -122.450467907345) | 15 | 6 | 2 | 54 | 16 | |||
185914 | 99306 | Permitted Site 7 | Tristania conferta :: 61 | 1345 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2012 12:00:00 AM | 3x3 | Permit Number 768843 | 6003605.0174 | 2112439.8748 | 37.780560974986 | -122.43114766452 | (37.780560974986, -122.43114766452) | 15 | 9 | 11 | 29490 | 41 | ||
185869 | 10407 | DPW Maintained 1 | Tristania conferta :: 61 | 1392 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2009 12:00:00 AM | 8 | 3x3 | 5999510.2425 | 2108793.466 | 37.7703159769785 | -122.445051169277 | (37.7703159769785, -122.445051169277) | 15 | 5 | 11 | 29492 | 9 | ||
185556 | 21607 | DPW Maintained 1 | Tristania conferta :: 61 | 1525 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6005102.2438 | 2114726.9152 | 37.7869253509843 | -122.426130907603 | (37.7869253509843, -122.426130907603) | 13 | 9 | 11 | 28858 | 13 | |||
185338 | 141842 | DPW Maintained 1 | Tristania conferta :: 61 | 1268 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/26/2011 12:00:00 AM | 1 | Width 0ft | 6004263.4746 | 2112800.275 | 37.7815878353953 | -122.428895449654 | (37.7815878353953, -122.428895449654) | 7 | 9 | 11 | 29490 | 41 | ||
185203 | 10693 | DPW Maintained 1 | Tristania conferta :: 61 | 1250 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6001870.5552 | 2110507.5567 | 37.7751568758154 | -122.43700960221 | (37.7751568758154, -122.43700960221) | 15 | 5 | 11 | 29492 | 10 | |||
185119 | 245200 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6001317.1669 | 2109106.4404 | 37.7712782916002 | -122.438823465977 | (37.7712782916002, -122.438823465977) | 15 | 5 | 11 | 29492 | 9 | |||
185033 | 139849 | DPW Maintained 1 | Tristania conferta :: 61 | 745 GOUGH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005731.0762 | 2112361.9465 | 37.7804672513308 | -122.423787065789 | (37.7804672513308, -122.423787065789) | 7 | 9 | 11 | 28852 | 41 | |||
184775 | 138598 | DPW Maintained 1 | Tristania conferta :: 61 | 1951 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6001454.5399 | 2115120.9706 | 37.7878004824405 | -122.43877935082 | (37.7878004824405, -122.43877935082) | 13 | 6 | 1 | 29490 | 27 | |||
184661 | 138910 | DPW Maintained 1 | Tristania conferta :: 61 | 723 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004255.8027 | 2110792.7816 | 37.7760753202825 | -122.428778835375 | (37.7760753202825, -122.428778835375) | 7 | 9 | 11 | 28852 | 10 | |||
184504 | 199817 | DPW Maintained 1 | Tristania conferta :: 61 | 2240 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015723.8893 | 2091960.1023 | 37.7250071238567 | -122.387792975779 | (37.7250071238567, -122.387792975779) | 10 | 3 | 8 | 58 | 1 | |||
184456 | 57431 | DPW Maintained 1 | Tristania conferta :: 61 | 1933 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/1991 12:00:00 AM | 8 | Permit Number 30044 | 6003885.286 | 2115132.8962 | 37.7879712148727 | -122.430370279075 | (37.7879712148727, -122.430370279075) | 13 | 9 | 11 | 29490 | 27 | ||
184432 | 58337 | DPW Maintained 1 | Tristania conferta :: 61 | 1593 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/1978 12:00:00 AM | 12 | Permit Number 17362 | 6000161.6495 | 2110915.9391 | 37.7761809090553 | -122.442950404096 | (37.7761809090553, -122.442950404096) | 15 | 5 | 11 | 29492 | 16 | ||
184424 | 138523 | DPW Maintained 1 | Tristania conferta :: 61 | 1604 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001653.2482 | 2114047.3958 | 37.7848640239748 | -122.438014928593 | (37.7848640239748, -122.438014928593) | 13 | 6 | 11 | 29490 | 13 | |||
184367 | 142158 | DPW Maintained 1 | Tristania conferta :: 61 | 1401 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001026.1857 | 2110695.1979 | 37.7756240617542 | -122.439943915036 | (37.7756240617542, -122.439943915036) | 15 | 5 | 11 | 29492 | 10 | |||
184109 | 47069 | DPW Maintained 1 | Tristania conferta :: 61 | 606 Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | 5 | Permit Number 45052 | 6004039.0188 | 2110889.0487 | 37.7763273741764 | -122.429535615559 | (37.7763273741764, -122.429535615559) | 7 | 9 | 11 | 28852 | 10 | ||
184042 | 200510 | DPW Maintained 1 | Tristania conferta :: 61 | 5913 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6013756.9175 | 2091787.9175 | 37.7244251810597 | -122.394580579707 | (37.7244251810597, -122.394580579707) | 10 | 3 | 8 | 58 | 1 | |||
183956 | 141175 | DPW Maintained 1 | Tristania conferta :: 61 | 1884 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6001840.8608 | 2112934.4278 | 37.7818187645096 | -122.437286131192 | (37.7818187645096, -122.437286131192) | 15 | 5 | 11 | 29490 | 41 | |||
183710 | 17671 | DPW Maintained 1 | Tristania conferta :: 61 | 1015X Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/05/1995 12:00:00 AM | 12 | 3X3 | 6002380.7463 | 2112056.356 | 37.779438476782 | -122.435355552273 | (37.779438476782, -122.435355552273) | 15 | 5 | 11 | 29490 | 41 | ||
183638 | 141814 | DPW Maintained 1 | Tristania conferta :: 61 | 621 WILLOW ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004559.3867 | 2113103.2378 | 37.7824364405973 | -122.427893329205 | (37.7824364405973, -122.427893329205) | 7 | 9 | 11 | 29490 | 41 | |||
183630 | 244270 | DPW Maintained 1 | Tristania conferta :: 61 | 110 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005991.7437 | 2110043.7472 | 37.7741167501745 | -122.422720502604 | (37.7741167501745, -122.422720502604) | 7 | 9 | 11 | 28852 | 10 | |||
183627 | 200799 | DPW Maintained 1 | Tristania conferta :: 61 | 5307 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6014333.8188 | 2093306.6984 | 37.7286275041699 | -122.392692492636 | (37.7286275041699, -122.392692492636) | 10 | 3 | 8 | 58 | 1 | |||
183590 | 138399 | DPW Maintained 1 | Tristania conferta :: 61 | 2445 PINE ST | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6002411.2137 | 2115044.4135 | 37.7876446559027 | -122.435463964972 | (37.7876446559027, -122.435463964972) | 13 | 6 | 11 | 29490 | 27 | |||
183503 | 142654 | DPW Maintained 1 | Tristania conferta :: 61 | 1188 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6007961.2413 | 2121229.1008 | 37.8049399144717 | -122.416700206529 | (37.8049399144717, -122.416700206529) | 5 | 1 | 10 | 308 | 23 | |||
183125 | 29440 | DPW Maintained 1 | Tristania conferta :: 61 | 2301X Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6015660.6839 | 2091799.6156 | 37.7245629575419 | -122.388000277891 | (37.7245629575419, -122.388000277891) | 10 | 3 | 8 | 58 | 1 | ||
182945 | 141378 | DPW Maintained 1 | Tristania conferta :: 61 | 1184 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6001791.5464 | 2110153.0032 | 37.7741788694777 | -122.437257518487 | (37.7741788694777, -122.437257518487) | 15 | 5 | 11 | 29492 | 10 | |||
182936 | 245464 | DPW Maintained 1 | Tristania conferta :: 61 | 2601 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008830.1741 | 2106813.5651 | 37.76540715826 | -122.412673439915 | (37.76540715826, -122.412673439915) | 8 | 4 | 7 | 28859 | 19 | |||
182717 | 6187 | DPW Maintained 1 | Tristania conferta :: 61 | 1100 Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005423.3129 | 2113433.3911 | 37.783391795987 | -122.424928016493 | (37.783391795987, -122.424928016493) | 7 | 9 | 11 | 28858 | 41 | |||
181832 | 12267 | DPW Maintained 1 | Tristania conferta :: 61 | 649 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2005 12:00:00 AM | 3 | 3X3 | 6004918.0391 | 2111202.3941 | 37.7772374748382 | -122.426517155351 | (37.7772374748382, -122.426517155351) | 7 | 9 | 11 | 28852 | 10 | ||
181597 | 140558 | DPW Maintained 1 | Tristania conferta :: 61 | 1165 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003608.4211 | 2111742.4986 | 37.7786463463413 | -122.431086100459 | (37.7786463463413, -122.431086100459) | 15 | 9 | 11 | 29492 | 41 | |||
181534 | 5215 | DPW Maintained 1 | Tristania conferta :: 61 | 846 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/1990 12:00:00 AM | 18 | 3X3 | 6001547.7869 | 2111374.9525 | 37.7775201753497 | -122.438188278406 | (37.7775201753497, -122.438188278406) | 15 | 5 | 11 | 29492 | 41 | ||
181310 | 13233 | DPW Maintained 1 | Tristania conferta :: 61 | 2301X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001245.6832 | 2119299.2908 | 37.7992611751931 | -122.439801639901 | (37.7992611751931, -122.439801639901) | 13 | 9 | 1 | 57 | 17 | |||
181307 | 246077 | DPW Maintained 1 | Tristania conferta :: 61 | 1221 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1980 12:00:00 AM | 6 | Width 0ft | Permit Number 17671 | 5999841.5143 | 2108446.1238 | 37.769381164613 | -122.443880345259 | (37.769381164613, -122.443880345259) | 15 | 5 | 11 | 29492 | 9 | |
181240 | 244271 | DPW Maintained 1 | Tristania conferta :: 61 | 114 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005957.8115 | 2110036.9608 | 37.7740962018433 | -122.422837397781 | (37.7740962018433, -122.422837397781) | 7 | 9 | 11 | 28852 | 10 | |||
180990 | 6201 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005283.7179 | 2113361.2024 | 37.7831856976936 | -122.42540582178 | (37.7831856976936, -122.42540582178) | 7 | 9 | 11 | 28858 | 41 | |||
180727 | 199657 | DPW Maintained 1 | Tristania conferta :: 61 | 1395 Donner Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015062.4933 | 2090889.5822 | 37.7220310269415 | -122.390004620276 | (37.7220310269415, -122.390004620276) | 10 | 3 | 8 | 58 | 1 | |||
180500 | 199893 | DPW Maintained 1 | Tristania conferta :: 61 | 1700 Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016554.6632 | 2093059.5354 | 37.7280719375741 | -122.384997617963 | (37.7280719375741, -122.384997617963) | 10 | 3 | 8 | 58 | 1 | |||
180381 | 199709 | DPW Maintained 1 | Tristania conferta :: 61 | 1925 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016317.7981 | 2092670.0851 | 37.7269894791605 | -122.385789342511 | (37.7269894791605, -122.385789342511) | 10 | 3 | 8 | 58 | 1 | |||
179984 | 13141 | DPW Maintained 1 | Tristania conferta :: 61 | 1790 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6003874.0187 | 2119744.4452 | 37.8006327105148 | -122.430738476202 | (37.8006327105148, -122.430738476202) | 13 | 9 | 1 | 57 | 17 | |||
179908 | 9596 | DPW Maintained 1 | Tristania conferta :: 61 | 1340 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 11 | 3X3 | 6003149.1044 | 2112077.4625 | 37.7795400355594 | -122.432698986969 | (37.7795400355594, -122.432698986969) | 15 | 9 | 11 | 29490 | 41 | ||
179906 | 200930 | DPW Maintained 1 | Tristania conferta :: 61 | 4101 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015555.39 | 2097392.3592 | 37.7399136731123 | -122.388754515291 | (37.7399136731123, -122.388754515291) | 10 | 3 | 8 | 58 | 1 | |||
179871 | 28075 | DPW Maintained 1 | Tristania conferta :: 61 | 915 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2010 12:00:00 AM | 3 | 3X3 | 6008651.5543 | 2120512.2278 | 37.8030103621977 | -122.414260542242 | (37.8030103621977, -122.414260542242) | 3 | 1 | 10 | 308 | 32 | ||
179764 | 200660 | DPW Maintained 1 | Tristania conferta :: 61 | 1528 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6015206.7042 | 2095389.6827 | 37.7343954004192 | -122.389820286473 | (37.7343954004192, -122.389820286473) | 10 | 3 | 8 | 58 | 1 | |||
179595 | 28833 | DPW Maintained 1 | Tristania conferta :: 61 | 1500 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016963.5397 | 2093616.3588 | 37.7296234731469 | -122.383622854715 | (37.7296234731469, -122.383622854715) | 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) );