trees
713 rows where qSpecies_id = 102
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20685 | 103447 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 24 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
20720 | 223188 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 100 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007765.60912 | 2096998.87207 | 37.7383984271532 | -122.415660555692 | (37.7383984271532, -122.415660555692) | 2 | 7 | 7 | 28859 | 2 | |||
20837 | 39081 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 816 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | Permit Number 40779 | 6009882.35970531 | 2104453.69348919 | 37.758986484759 | -122.408867645938 | (37.758986484759, -122.408867645938) | 2 | 4 | 7 | 28859 | 19 | ||
20965 | 37421 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1215 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39901 | 6003240.50544879 | 2101168.34074207 | 37.7495914114978 | -122.431603738981 | (37.7495914114978, -122.431603738981) | 2 | 4 | 5 | 28862 | 22 | ||
21451 | 223252 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 223 Buena Vista Ave East | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001379.7968 | 2108143.42128 | 37.7686376435263 | -122.438537815694 | (37.7686376435263, -122.438537815694) | 15 | 5 | 5 | 29492 | 3 | |||
21503 | 223143 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 605 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002444.15174 | 2102068.56819 | 37.7520180525139 | -122.434421909144 | (37.7520180525139, -122.434421909144) | 2 | 4 | 5 | 28862 | 22 | |||
21672 | 36567 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 281 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/19/1998 12:00:00 AM | Permit Number 39429 | 6006271.54294487 | 2096111.84764875 | 37.7358787559596 | -122.420763362902 | (37.7358787559596, -122.420763362902) | 2 | 7 | 7 | 28859 | 2 | ||
22064 | 113315 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2493x 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5984243.3692 | 2098259.1068 | 37.7405083669922 | -122.497080760951 | (37.7405083669922, -122.497080760951) | 1 | 8 | 3 | 29491 | 35 | |||
22791 | 126391 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3570 Clay St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 5997748.40757 | 2115473.64195 | 37.7885572815394 | -122.451627258297 | (37.7885572815394, -122.451627258297) | 11 | 6 | 1 | 54 | 31 | |||
23152 | 206764 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1550 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995805.65457 | 2094327.40967 | 37.7303836780568 | -122.456818834923 | (37.7303836780568, -122.456818834923) | 9 | 7 | 4 | 28861 | 40 | |||
23347 | 206742 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 647 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5997796.56298 | 2094976.80615 | 37.7322808851511 | -122.449982803857 | (37.7322808851511, -122.449982803857) | 9 | 7 | 4 | 59 | 40 | |||
23447 | 37412 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 920 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39890 | 6001892.73765623 | 2101410.4821696 | 37.7501797894928 | -122.436281684424 | (37.7501797894928, -122.436281684424) | 2 | 4 | 5 | 28862 | 22 | ||
23893 | 206710 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1370 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5991484.15293 | 2106105.9073 | 37.7624753009047 | -122.472617151554 | (37.7624753009047, -122.472617151554) | 1 | 8 | 11 | 56 | 12 | |||
23956 | 255489 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 415 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781958 | 6004580.17678 | 2109974.62519 | 37.7738472162761 | -122.427598435585 | (37.7738472162761, -122.427598435585) | 7 | 9 | 11 | 28852 | 10 |
24421 | 206756 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2245 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991004.48671 | 2100128.5419 | 37.7460352505192 | -122.473840030798 | (37.7460352505192, -122.473840030798) | 1 | 8 | 4 | 29491 | 40 | |||
24521 | 34871 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 362 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39900 | 6002791.72644386 | 2101550.82973484 | 37.7506161886226 | -122.433182956314 | (37.7506161886226, -122.433182956314) | 2 | 4 | 5 | 28862 | 22 | ||
24718 | 190936 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6012268.87212 | 2103730.35281 | 37.7571337389375 | -122.400563099634 | (37.7571337389375, -122.400563099634) | 10 | 3 | 8 | 28856 | 29 | |||
24775 | 223151 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1 Mizpah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001079.42041 | 2096656.30297 | 37.7370796927675 | -122.438753546857 | (37.7370796927675, -122.438753546857) | 2 | 7 | 5 | 63 | 7 | |||
24836 | 96563 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 567 Moultrie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2011 12:00:00 AM | Permit Number 767781 | 6007698 | 2096716 | 37.7376179219065 | -122.415874290579 | (37.7376179219065, -122.415874290579) | 2 | 7 | 7 | 28859 | 2 | ||||
24895 | 35947 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 354 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39109 | 6007155.94334709 | 2095722.46816688 | 37.734859413246 | -122.417678043362 | (37.734859413246, -122.417678043362) | 2 | 7 | 7 | 28859 | 2 | ||
25089 | 206711 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1366 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5991481.24454 | 2106127.13421 | 37.7625334160042 | -122.472628758222 | (37.7625334160042, -122.472628758222) | 1 | 8 | 11 | 56 | 12 | |||
26030 | 206732 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2430 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991403.39763 | 2098862.37414 | 37.7425817765239 | -122.472368375716 | (37.7425817765239, -122.472368375716) | 1 | 8 | 4 | 29491 | 40 | |||
26169 | 206759 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1500 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995896.88081 | 2094136.36483 | 37.7298643528405 | -122.456489645298 | (37.7298643528405, -122.456489645298) | 9 | 7 | 4 | 28861 | 40 | |||
26560 | 206771 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 59 El Verano Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994676.70576 | 2094842.34455 | 37.7317326737219 | -122.46075904452 | (37.7317326737219, -122.46075904452) | 9 | 8 | 4 | 59 | 40 | |||
26568 | 223100 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 323 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003606.73212 | 2099501.75827 | 37.7450361154323 | -122.43021843293 | (37.7450361154323, -122.43021843293) | 2 | 7 | 5 | 63 | 22 | |||
26826 | 49650 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 160 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2003 12:00:00 AM | Permit Number 46504 | 5993337.43694089 | 2094535.94135118 | 37.7308142184714 | -122.465366881335 | (37.7308142184714, -122.465366881335) | 9 | 8 | 4 | 59 | 40 | |||
26989 | 42903 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3267 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42817 | 6007744.73028146 | 2104990.07889872 | 37.7603393072133 | -122.416298586055 | (37.7603393072133, -122.416298586055) | 2 | 4 | 7 | 28859 | 19 | ||
27308 | 206763 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1550 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995815.46326 | 2094322.90602 | 37.7303718753392 | -122.456784599525 | (37.7303718753392, -122.456784599525) | 9 | 7 | 4 | 28861 | 40 | |||
27356 | 250731 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2745 Lake St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986887.59373 | 2114422.31311 | 37.785042671624 | -122.489126191619 | (37.785042671624, -122.489126191619) | 11 | 6 | 1 | 55 | 33 | |||
27660 | 36691 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 15 Bird St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39490 | 6005970.65710535 | 2105699.54901563 | 37.7621874267643 | -122.42248469974 | (37.7621874267643, -122.42248469974) | 8 | 4 | 5 | 28859 | 19 | ||
27807 | 37883 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 661 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40161 | 5995348.10661971 | 2093729.21592258 | 37.7287148993258 | -122.458357350083 | (37.7287148993258, -122.458357350083) | 9 | 7 | 4 | 28861 | 40 | ||
27906 | 103441 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 18 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
28151 | 190948 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 40 Bluxome St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6013368.27074 | 2110817.70841 | 37.7766552947402 | -122.397257911242 | (37.7766552947402, -122.397257911242) | 6 | 2 | 9 | 28856 | 34 | |||
28323 | 206708 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1926 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5991286.95111 | 2102293.22218 | 37.7519952564944 | -122.473021145018 | (37.7519952564944, -122.473021145018) | 1 | 8 | 4 | 29491 | 12 | |||
28412 | 223085 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1383 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010105.40683 | 2101175.29906 | 37.7499972353919 | -122.407865061343 | (37.7499972353919, -122.407865061343) | 2 | 4 | 7 | 28859 | 19 | |||
28427 | 126393 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 405 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5998114.64668 | 2115082.3398 | 37.7875038363742 | -122.450331914389 | (37.7875038363742, -122.450331914389) | 11 | 6 | 1 | 54 | 31 | |||
28799 | 31813 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 75 Park Hill Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43298 | 6001169.8510551 | 2107531.3716561 | 37.7669451622371 | -122.439220125413 | (37.7669451622371, -122.439220125413) | 15 | 5 | 5 | 29492 | 3 | ||
28874 | 46095 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 647 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2001 12:00:00 AM | Permit Number 44466 | 5995953.68098218 | 2095998.76752974 | 37.734981320791 | -122.456427900432 | (37.734981320791, -122.456427900432) | 9 | 7 | 4 | 59 | 40 | |||
29107 | 190945 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 40 Bluxome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6013445.03636 | 2110888.0497 | 37.7768527094247 | -122.396997287698 | (37.7768527094247, -122.396997287698) | 6 | 2 | 9 | 28856 | 34 | |||
29257 | 37356 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 62 Florentine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 5 | Permit Number 39862 | 5999496.07093 | 2087702.97116 | 37.7124057060181 | -122.443584900943 | (37.7124057060181, -122.443584900943) | 9 | 7 | 6 | 28861 | 5 | |
29702 | 223141 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4644 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000468.40561 | 2101124.67323 | 37.7493139961397 | -122.441186594305 | (37.7493139961397, -122.441186594305) | 2 | 4 | 5 | 28862 | 22 | |||
29874 | 126390 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3751 Sacramento St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996763.42592 | 2114965.78353 | 37.7871063810023 | -122.454998413757 | (37.7871063810023, -122.454998413757) | 11 | 6 | 1 | 54 | 31 | |||
29934 | 49988 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 300@ GOUGH Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2003 12:00:00 AM | 2 | Permit Number 46733 | 6005922.1673 | 2110886.7951 | 37.7764276301155 | -122.423021112586 | (37.7764276301155, -122.423021112586) | 7 | 9 | 11 | 28852 | 10 | ||
30310 | 206768 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 24 Merced Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995217.94161 | 2100123.23071 | 37.7462638105263 | -122.459270173693 | (37.7462638105263, -122.459270173693) | 1 | 8 | 4 | 59 | 40 | |||
30589 | 46576 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 996 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/05/2002 12:00:00 AM | Permit Number 44710 | 6003759.39576103 | 2102474.00246404 | 37.7532058498338 | -122.429902520856 | (37.7532058498338, -122.429902520856) | 2 | 4 | 5 | 28862 | 22 | ||
30784 | 84349 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 333 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50602 | 6006744.47832295 | 2104177.6342219 | 37.758052226043 | -122.419700351439 | (37.758052226043, -122.419700351439) | 2 | 4 | 7 | 28859 | 19 | ||
31335 | 42183 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 730 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42467 | 6012299.41281254 | 2111097.65921114 | 37.7773644110039 | -122.400975101339 | (37.7773644110039, -122.400975101339) | 14 | 2 | 9 | 28856 | 34 | ||
31389 | 223238 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3819 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004233.22031 | 2104799.55992 | 37.7596181035173 | -122.428429683205 | (37.7596181035173, -122.428429683205) | 2 | 4 | 5 | 28862 | 3 | |||
31442 | 126387 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3751 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996876.15534 | 2114980.73672 | 37.7871539047628 | -122.454609477651 | (37.7871539047628, -122.454609477651) | 11 | 6 | 1 | 54 | 31 | |||
32339 | 223182 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 300 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006910.11223 | 2097068.32628 | 37.7385410056619 | -122.41862337757 | (37.7385410056619, -122.41862337757) | 2 | 7 | 7 | 28859 | 2 | |||
32362 | 206744 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 360 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5997700.14288 | 2093824.21589 | 37.7291106283493 | -122.450233097774 | (37.7291106283493, -122.450233097774) | 9 | 7 | 4 | 28861 | 40 | |||
32480 | 51271 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 762 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2004 12:00:00 AM | 3 | Permit Number 47646 | 5991020.68747 | 2110207.63616 | 37.7737107039086 | -122.474519447105 | (37.7737107039086, -122.474519447105) | 11 | 6 | 2 | 54 | 26 | |
32830 | 206741 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 527 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997915.91197 | 2094377.49902 | 37.7306421584929 | -122.449527021155 | (37.7306421584929, -122.449527021155) | 9 | 7 | 4 | 28861 | 40 | |||
33441 | 206753 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 355 Parnassus Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 5ft | 5996046.6732 | 2106441.49184 | 37.7636597709952 | -122.456861438509 | (37.7636597709952, -122.456861438509) | 15 | 5 | 4 | 29492 | 12 | |||
34628 | 223262 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 214 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003313.48049 | 2109165.67905 | 37.7715543194136 | -122.431922366729 | (37.7715543194136, -122.431922366729) | 15 | 9 | 11 | 29492 | 10 | |||
34656 | 223146 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1543 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003344.33647 | 2099293.67104 | 37.7444498905663 | -122.431110900363 | (37.7444498905663, -122.431110900363) | 2 | 7 | 5 | 63 | 22 | |||
35038 | 206706 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1479 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5991135.60294 | 2105348.51695 | 37.7603755269382 | -122.473767390769 | (37.7603755269382, -122.473767390769) | 1 | 8 | 4 | 56 | 12 | |||
35636 | 46604 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 657 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2002 12:00:00 AM | Permit Number 44730 | 5995879.19387821 | 2095995.46855673 | 37.7349679860764 | -122.456685188603 | (37.7349679860764, -122.456685188603) | 9 | 7 | 4 | 59 | 40 | |||
35776 | 223254 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 12 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6001416.18598 | 2108119.15554 | 37.7685730857195 | -122.438410209957 | (37.7685730857195, -122.438410209957) | 15 | 5 | 5 | 29492 | 3 | |||
35886 | 42461 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 638 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42603 | 5997203.88330057 | 2095296.86249192 | 37.7331257521174 | -122.45205490562 | (37.7331257521174, -122.45205490562) | 9 | 7 | 4 | 59 | 40 | ||
35923 | 40727 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 242 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2002 12:00:00 AM | Permit Number 41706 | 6008971.38235478 | 2097242.21876487 | 37.7391343108464 | -122.411508751405 | (37.7391343108464, -122.411508751405) | 10 | 7 | 7 | 28859 | 2 | ||
36056 | 83944 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2619 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52652 | 6010400.97039498 | 2103382.22541329 | 37.7560735087835 | -122.406998516177 | (37.7560735087835, -122.406998516177) | 10 | 4 | 7 | 28859 | 19 | ||
36063 | 223116 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 13 Stoneman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008405.91567 | 2099418.14842 | 37.7450772000642 | -122.413617744757 | (37.7450772000642, -122.413617744757) | 2 | 7 | 7 | 28859 | 2 | |||
36636 | 223184 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 39 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006986.80584 | 2097054.98835 | 37.7385087002251 | -122.418357261872 | (37.7385087002251, -122.418357261872) | 2 | 7 | 7 | 28859 | 2 | |||
36656 | 50121 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 251 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2003 12:00:00 AM | Permit Number 46844 | 5992306.20915001 | 2097823.24522432 | 37.7397808029858 | -122.469171133031 | (37.7397808029858, -122.469171133031) | 1 | 8 | 4 | 59 | 40 | ||
36801 | 39544 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1947 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52628 | 6012257.26801 | 2103730.73131 | 37.7571341310464 | -122.400603257944 | (37.7571341310464, -122.400603257944) | 10 | 3 | 8 | 28856 | 29 | |
36830 | 206713 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1835 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993730.54086 | 2103003.335 | 37.7540862153215 | -122.464622482542 | (37.7540862153215, -122.464622482542) | 1 | 8 | 4 | 56 | 12 | |||
36871 | 37013 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2649 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39627 | 6008937.84413531 | 2103040.08708157 | 37.7550520906222 | -122.412034337856 | (37.7550520906222, -122.412034337856) | 2 | 4 | 7 | 28859 | 19 | ||
37015 | 39548 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40973 | 6012286.64815743 | 2103730.55141744 | 37.7571352756248 | -122.400501636831 | (37.7571352756248, -122.400501636831) | 10 | 3 | 8 | 28856 | 29 | ||
37017 | 223065 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 436 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005845.27485 | 2107876.32583 | 37.7681572661617 | -122.423073077374 | (37.7681572661617, -122.423073077374) | 8 | 4 | 5 | 28853 | 19 | |||
37595 | 206755 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2249 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991006.69103 | 2100092.27446 | 37.7459357971944 | -122.473829763244 | (37.7459357971944, -122.473829763244) | 1 | 8 | 4 | 29491 | 40 | |||
37717 | 35412 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1543 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38867 | 6003346.45221762 | 2099263.3283709 | 37.7443666965298 | -122.431101419272 | (37.7443666965298, -122.431101419272) | 2 | 7 | 5 | 63 | 22 | ||
38105 | 223211 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 263 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003447.74658 | 2100952.52309 | 37.7490105711977 | -122.430871692397 | (37.7490105711977, -122.430871692397) | 2 | 4 | 5 | 28862 | 22 | |||
38263 | 206777 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 339 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5995709.16123 | 2098486.51672 | 37.7417980290669 | -122.457453213121 | (37.7417980290669, -122.457453213121) | 1 | 8 | 4 | 59 | 40 | |||
39104 | 190941 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1701 Newhall St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6013964.79274 | 2095080.10635 | 37.7334764187035 | -122.394092347086 | (37.7334764187035, -122.394092347086) | 10 | 3 | 8 | 58 | 1 | |||
39237 | 39738 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3892 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41105 | 6003712.19802155 | 2104818.42047752 | 37.759640392907 | -122.430232983891 | (37.759640392907, -122.430232983891) | 2 | 4 | 5 | 28862 | 3 | ||
39701 | 206703 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1917 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5990930.40398 | 2102318.91188 | 37.75204514457 | -122.474255998729 | (37.75204514457, -122.474255998729) | 1 | 8 | 4 | 29491 | 12 | |||
39731 | 223155 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 43 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001836.39965 | 2096899.00192 | 37.7377891238618 | -122.436153694935 | (37.7377891238618, -122.436153694935) | 2 | 7 | 5 | 63 | 7 | |||
40193 | 40224 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 178 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51169 | 6001542.41126351 | 2095210.63653579 | 37.7331365563636 | -122.4370493102 | (37.7331365563636, -122.4370493102) | 9 | 7 | 5 | 63 | 40 | ||
40278 | 206783 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 570 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5997661.8158 | 2095278.69851 | 37.7331020983833 | -122.4504704091 | (37.7331020983833, -122.4504704091) | 9 | 7 | 4 | 59 | 40 | |||
40399 | 37909 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1550 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40172 | 5995790.86348938 | 2094355.79804067 | 37.7304607763423 | -122.456872021896 | (37.7304607763423, -122.456872021896) | 9 | 7 | 4 | 28861 | 40 | ||
40443 | 223134 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 58 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005929.62403 | 2102889.79812 | 37.754470191658 | -122.42242696485 | (37.754470191658, -122.42242696485) | 2 | 4 | 5 | 28859 | 19 | |||
40706 | 223218 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 416 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003713.68797 | 2102768.42852 | 37.754011685803 | -122.430081589403 | (37.754011685803, -122.430081589403) | 2 | 4 | 5 | 28862 | 22 | |||
40762 | 33518 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 152 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2011 12:00:00 AM | Permit Number 54708 | 6007356.74297376 | 2098199.21824128 | 37.7416713195812 | -122.417159251481 | (37.7416713195812, -122.417159251481) | 2 | 7 | 7 | 28859 | 2 | |||
41560 | 206719 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1624 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5992799.45091 | 2104376.41203 | 37.757802607033 | -122.467942255237 | (37.757802607033, -122.467942255237) | 1 | 8 | 4 | 56 | 12 | |||
41573 | 223136 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 77 Leese St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005562.24439 | 2096226.76461 | 37.7361542885824 | -122.423223857715 | (37.7361542885824, -122.423223857715) | 2 | 7 | 7 | 28859 | 2 | |||
41798 | 223241 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 64 Collingwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001986.08846 | 2105493.47315 | 37.7613960047459 | -122.436251036661 | (37.7613960047459, -122.436251036661) | 15 | 4 | 5 | 28862 | 3 | |||
41923 | 49925 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 554 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | 3x3 | Permit Number 46683 | 6007843.47911818 | 2104700.44166779 | 37.7595495823703 | -122.415936548093 | (37.7595495823703, -122.415936548093) | 2 | 4 | 7 | 28859 | 19 | |
42458 | 223245 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 253 Buena Vista Ave East | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001239.96378 | 2107994.47074 | 37.7682207070384 | -122.439010809627 | (37.7682207070384, -122.439010809627) | 15 | 5 | 5 | 29492 | 3 | |||
42671 | 58692 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 323 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2009 12:00:00 AM | 3x3 | Permit Number 767328 | 6003795.85086408 | 2099507.29514061 | 37.7450620283206 | -122.429564888975 | (37.7450620283206, -122.429564888975) | 2 | 7 | 5 | 63 | 22 | |
42852 | 223069 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 17 Bird St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6005932.67721 | 2105708.05558 | 37.7622086411481 | -122.422616662448 | (37.7622086411481, -122.422616662448) | 8 | 4 | 5 | 28859 | 19 | |||
43021 | 176078 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 230 Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012689.21584 | 2087374.22772 | 37.7122466573345 | -122.397962026443 | (37.7122466573345, -122.397962026443) | 10 | 3 | 8 | 309 | 1 | |||
43301 | 46603 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 657 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2007 12:00:00 AM | Permit No. 49245 | 5995879.19387821 | 2095995.46855673 | 37.7349679860764 | -122.456685188603 | (37.7349679860764, -122.456685188603) | 9 | 7 | 4 | 59 | 40 | |||
43339 | 123459 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 473 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5995269.10945 | 2112350.33897 | 37.7798392345462 | -122.459978845187 | (37.7798392345462, -122.459978845187) | 11 | 6 | 2 | 54 | 11 | |||
43579 | 49061 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 800 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46227 | 5995425.29330578 | 2094224.97746193 | 37.7300805760009 | -122.45812637796 | (37.7300805760009, -122.45812637796) | 9 | 7 | 4 | 28861 | 40 | ||
43642 | 255804 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 151 Urbano Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 5993243 | 2092509 | 37.7252432887469 | -122.465546165723 | (37.7252432887469, -122.465546165723) | 9 | 8 | 4 | 59 | 40 | ||||
44445 | 52260 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3709 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/29/2005 12:00:00 AM | Permit Number 48425 | 6005749.88940983 | 2101370.1403687 | 37.7502874215485 | -122.422940534627 | (37.7502874215485, -122.422940534627) | 2 | 4 | 5 | 28859 | 19 | |||
44463 | 223249 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 223 Buena Vista Ave East | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001336.02074 | 2108072.32324 | 37.768439935683 | -122.438684138074 | (37.768439935683, -122.438684138074) | 15 | 5 | 5 | 29492 | 3 | |||
44807 | 121103 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1374 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5991487.33915366 | 2106070.76020768 | 37.7623789807661 | -122.472603569045 | (37.7623789807661, -122.472603569045) | 1 | 8 | 11 | 56 | 12 | |||
44862 | 114642 | Private 9 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 30 MacEdonia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 773527 | 6010319.9 | 2099707.2 | 37.745978163197 | -122.407019863158 | (37.745978163197, -122.407019863158) | 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) );