trees
3,267 rows where qSpecies_id = 67 sorted by Fire Prevention Districts 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43539 | 175599 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 192 Dublin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6004164.31837 | 2089345.24941 | 37.7171801843089 | -122.427566943762 | (37.7171801843089, -122.427566943762) | 9 | 7 | 6 | 28861 | 5 | |||
| 44453 | 204362 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 304 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5992231.07965 | 2089876.61874 | 37.7179569979942 | -122.468852772034 | (37.7179569979942, -122.468852772034) | 9 | 8 | 6 | 64 | 24 | |||
| 44905 | 1098 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2319 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 5999519.61819 | 2089252.78521 | 37.7166624877513 | -122.443614779103 | (37.7166624877513, -122.443614779103) | 9 | 7 | 6 | 28861 | 25 | |||
| 45072 | 205769 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 20 | Median : Cutout | Tree | DPW 1 | 8 | Width 5ft | 5999260.68226 | 2097573.72632 | 37.7394950820195 | -122.445107659105 | (37.7394950820195, -122.445107659105) | 9 | 7 | 4 | 59 | 40 | |||
| 45970 | 175700 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 230 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6007193.74486 | 2092567.94998 | 37.7261999194889 | -122.417323876092 | (37.7261999194889, -122.417323876092) | 9 | 3 | 7 | 309 | 28 | |||
| 46339 | 54188 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 758 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/2002 12:00:00 AM | Permit Number 40732 | 5994446.73850644 | 2089956.09273845 | 37.7183029732854 | -122.461200022537 | (37.7183029732854, -122.461200022537) | 9 | 8 | 6 | 28861 | 24 | ||
| 46384 | 204550 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 62 | Median : Cutout | Tree | DPW 1 | 12 | Width 5ft | 5999656.91248 | 2097430.30525 | 37.7391238895455 | -122.443727371535 | (37.7391238895455, -122.443727371535) | 9 | 7 | 4 | 59 | 40 | |||
| 46480 | 175670 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 220 Craut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004028.91634 | 2093910.51041 | 37.7297077233134 | -122.428360162915 | (37.7297077233134, -122.428360162915) | 9 | 7 | 6 | 28861 | 5 | |||
| 46782 | 204526 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 34 | Median : Cutout | Tree | DPW 1 | 10 | Width 3ft | 5999151.1241 | 2097003.92167 | 37.7379242802812 | -122.445445501119 | (37.7379242802812, -122.445445501119) | 9 | 7 | 4 | 59 | 40 | |||
| 47074 | 31181 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 521 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34879 | 5992668.86925851 | 2089822.40668247 | 37.7178334279778 | -122.467335598289 | (37.7178334279778, -122.467335598289) | 9 | 8 | 6 | 64 | 24 | ||
| 47180 | 175749 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 348 Naylor St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6002804.80085 | 2086492.54523 | 37.7092702907661 | -122.432062550353 | (37.7092702907661, -122.432062550353) | 9 | 7 | 6 | 28861 | 5 | |||
| 47212 | 175596 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 861 Lisbon St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6001043.54225 | 2088836.75005 | 37.715606945381 | -122.438317555522 | (37.715606945381, -122.438317555522) | 9 | 7 | 6 | 28861 | 5 | |||
| 47433 | 175686 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 212 Madison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6005601.68798 | 2092672.56295 | 37.7263974627707 | -122.422834968382 | (37.7263974627707, -122.422834968382) | 9 | 7 | 7 | 309 | 5 | |||
| 47660 | 204502 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 429 Hazelwood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995590.95327 | 2095806.74609 | 37.7344332461006 | -122.457668080921 | (37.7344332461006, -122.457668080921) | 9 | 7 | 4 | 59 | 40 | |||
| 47907 | 204561 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 480 Myra Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997216.31659 | 2096956.52778 | 37.7376835056979 | -122.452131626866 | (37.7376835056979, -122.452131626866) | 9 | 7 | 4 | 59 | 40 | |||
| 47923 | 62828 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1868 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1986 12:00:00 AM | Permit Number 23193 | 6000301.60270907 | 2093170.70232582 | 37.7274647632092 | -122.441192796651 | (37.7274647632092, -122.441192796651) | 9 | 7 | 6 | 28861 | 25 | ||
| 48141 | 175747 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 58 Baltimore Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6002963.82508 | 2086583.0162 | 37.709527718998 | -122.431519392204 | (37.709527718998, -122.431519392204) | 9 | 7 | 6 | 28861 | 5 | |||
| 48486 | 204539 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 6 | Median : Cutout | Tree | DPW 1 | 16 | Width 3ft | 5999517.17436 | 2097035.66414 | 37.7380323275304 | -122.444182170371 | (37.7380323275304, -122.444182170371) | 9 | 7 | 4 | 59 | 40 | |||
| 48712 | 205783 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 409 Hearst Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998710.69584 | 2094363.50347 | 37.730649165106 | -122.446778336843 | (37.730649165106, -122.446778336843) | 9 | 7 | 4 | 28861 | 40 | |||
| 49085 | 204374 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 546 Head St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993518.36116 | 2089503.4985 | 37.7170067869068 | -122.46437616365 | (37.7170067869068, -122.46437616365) | 9 | 8 | 6 | 64 | 24 | |||
| 49240 | 204363 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 304 Ralston St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5992230.03339 | 2089899.44154 | 37.7180196034048 | -122.468858048362 | (37.7180196034048, -122.468858048362) | 9 | 8 | 6 | 64 | 24 | |||
| 49472 | 24271 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300X Winding Way | 9 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6001388.30533 | 2086462.26856 | 37.7091067481538 | -122.436956008017 | (37.7091067481538, -122.436956008017) | 9 | 7 | 6 | 28861 | 5 | |||
| 49500 | 204570 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 404 Baden St | 2 | Side Yard : Yard | Tree | Private 2 | 3 | 6000772.02371 | 2095261.55097 | 37.733232536033 | -122.43971638892 | (37.733232536033, -122.43971638892) | 9 | 7 | 5 | 63 | 40 | ||||
| 49508 | 122384 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Melrose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | 5999501 | 2095545 | 37.7339383930574 | -122.444131009745 | (37.7339383930574, -122.444131009745) | 9 | 7 | 4 | 63 | 40 | ||||
| 50128 | 175624 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 21 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6009382.81472 | 2090013.8898 | 37.7193099237036 | -122.409576165411 | (37.7193099237036, -122.409576165411) | 9 | 3 | 8 | 309 | 18 | |||
| 50274 | 204563 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 480 Myra Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5997254.34429 | 2096968.45119 | 37.7377184227776 | -122.452001007542 | (37.7377184227776, -122.452001007542) | 9 | 7 | 4 | 59 | 40 | |||
| 50278 | 205858 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4 Lobos St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 5996833.75095 | 2088711.69181 | 37.7150232206213 | -122.452859401447 | (37.7150232206213, -122.452859401447) | 9 | 8 | 6 | 28861 | 24 | |||
| 50425 | 42399 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 Gennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42555 | 5997487.92419847 | 2095274.73436784 | 37.7330812596511 | -122.451071309951 | (37.7330812596511, -122.451071309951) | 9 | 7 | 4 | 59 | 40 | ||
| 50612 | 204471 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 246 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992621.02735 | 2095103.35423 | 37.7323308505861 | -122.467884856895 | (37.7323308505861, -122.467884856895) | 9 | 8 | 4 | 59 | 40 | |||
| 50699 | 67289 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1801 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1992 12:00:00 AM | Permit Number 30765 | 6005600.48989505 | 2092717.74835563 | 37.7265214644021 | -122.422842320006 | (37.7265214644021, -122.422842320006) | 9 | 7 | 7 | 309 | 5 | ||
| 50719 | 204389 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Rossmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 5991049.04584 | 2094416.57218 | 37.7303542198692 | -122.473269434337 | (37.7303542198692, -122.473269434337) | 9 | 8 | 4 | 64 | 40 | |||
| 51695 | 27098 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 681 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6005904.97939 | 2093585.43761 | 37.7289211250072 | -122.421851317801 | (37.7289211250072, -122.421851317801) | 9 | 7 | 6 | 28861 | 5 | |||
| 51819 | 175629 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 44 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6009095.75789 | 2089908.29383 | 37.7190038897951 | -122.410560964431 | (37.7190038897951, -122.410560964431) | 9 | 3 | 8 | 309 | 18 | |||
| 51992 | 175621 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 17 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6009441.92296 | 2090030.92164 | 37.7193600015446 | -122.409373050849 | (37.7193600015446, -122.409373050849) | 9 | 3 | 8 | 309 | 18 | |||
| 52153 | 205828 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 126 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995357.70352 | 2090747.56335 | 37.7205285473285 | -122.458108470822 | (37.7205285473285, -122.458108470822) | 9 | 8 | 6 | 28861 | 24 | |||
| 52372 | 205798 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 250 Foerster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998123.82989 | 2094209.28431 | 37.7301921728248 | -122.448796108854 | (37.7301921728248, -122.448796108854) | 9 | 7 | 4 | 28861 | 40 | |||
| 52516 | 204565 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 480 Myra Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997291.74057 | 2096975.61929 | 37.737740246615 | -122.451872228247 | (37.737740246615, -122.451872228247) | 9 | 7 | 4 | 59 | 40 | |||
| 52972 | 175734 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 327 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002802.82744 | 2086547.25146 | 37.7094203903216 | -122.432073274757 | (37.7094203903216, -122.432073274757) | 9 | 7 | 6 | 28861 | 5 | |||
| 53218 | 205822 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 88 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5996534.05939 | 2090432.88282 | 37.7197320303817 | -122.454019490902 | (37.7197320303817, -122.454019490902) | 9 | 8 | 6 | 28861 | 24 | |||
| 53666 | 204507 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 236 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996531.02619 | 2096213.13663 | 37.7356030545457 | -122.454447305622 | (37.7356030545457, -122.454447305622) | 9 | 7 | 4 | 59 | 40 | |||
| 54057 | 175627 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 42 | Median : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6009089.91396 | 2089921.07864 | 37.7190386665864 | -122.410582067034 | (37.7190386665864, -122.410582067034) | 9 | 3 | 8 | 309 | 18 | |||
| 54526 | 40684 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | Permit Number 41667 | 6004026.21190005 | 2093997.85413123 | 37.7299473965939 | -122.428375735336 | (37.7299473965939, -122.428375735336) | 9 | 7 | 6 | 28861 | 5 | ||
| 54749 | 204510 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 85 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995479.85207 | 2096197.53085 | 37.7354998627148 | -122.458080464149 | (37.7354998627148, -122.458080464149) | 9 | 7 | 4 | 59 | 40 | |||
| 54919 | 204381 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 47 Ralston St | 4 | Back Yard : Yard | Tree | Private 2 | 5 | 5992175.93878 | 2088248.61457 | 37.7134837071825 | -122.468924959729 | (37.7134837071825, -122.468924959729) | 9 | 8 | 6 | 64 | 24 | ||||
| 54997 | 31001 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 285 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 9 | Permit Number 34778 | 6002746.71825 | 2086679.2341 | 37.709779604712 | -122.432276616899 | (37.709779604712, -122.432276616899) | 9 | 7 | 6 | 28861 | 5 | |
| 55353 | 175689 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1419 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007497.28407 | 2091377.76414 | 37.7229489970823 | -122.416190298655 | (37.7229489970823, -122.416190298655) | 9 | 3 | 7 | 309 | 28 | |||
| 55871 | 175595 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 27 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6001772.06496 | 2091793.1589 | 37.7237659924901 | -122.436010880815 | (37.7237659924901, -122.436010880815) | 9 | 7 | 6 | 28861 | 25 | |||
| 55927 | 204522 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 40 | Median : Cutout | Tree | DPW 1 | 15 | Width 3ft | 5999115.3748 | 2096989.84123 | 37.7378835778536 | -122.445568091304 | (37.7378835778536, -122.445568091304) | 9 | 7 | 4 | 59 | 40 | |||
| 56671 | 24272 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300X Winding Way | 10 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6001382.61488 | 2086464.98759 | 37.7091138905754 | -122.436975869563 | (37.7091138905754, -122.436975869563) | 9 | 7 | 6 | 28861 | 5 | |||
| 57577 | 205845 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Jules Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994459.49219 | 2090019.51391 | 37.7184778466456 | -122.46116053335 | (37.7184778466456, -122.46116053335) | 9 | 8 | 6 | 28861 | 24 | |||
| 58237 | 205819 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 Marston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 1ft | 5998627.13383 | 2093189.37891 | 37.7274205207388 | -122.446982762652 | (37.7274205207388, -122.446982762652) | 9 | 7 | 4 | 28861 | 40 | |||
| 58462 | 57605 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 250 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/1976 12:00:00 AM | 3x3 | Permit Number 26693 | 5999752.23932038 | 2094391.78344807 | 37.7307862598115 | -122.443179604218 | (37.7307862598115, -122.443179604218) | 9 | 7 | 4 | 63 | 40 | ||
| 58552 | 42397 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 Gennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42555 | 5997487.92419847 | 2095274.73436784 | 37.7330812596511 | -122.451071309951 | (37.7330812596511, -122.451071309951) | 9 | 7 | 4 | 59 | 40 | ||
| 59223 | 66041 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 74 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1990 12:00:00 AM | 13 | Permit Number 29080 | 6004614.4703 | 2093089.36495 | 37.7274861568572 | -122.426277398677 | (37.7274861568572, -122.426277398677) | 9 | 7 | 6 | 28861 | 5 | ||
| 59291 | 204365 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 294 Ramsell St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5992993.26737 | 2089135.18818 | 37.715965213689 | -122.46616439447 | (37.715965213689, -122.46616439447) | 9 | 8 | 6 | 64 | 24 | |||
| 59523 | 205794 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 618 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5997298.05605 | 2094421.90373 | 37.7307287182504 | -122.451666234016 | (37.7307287182504, -122.451666234016) | 9 | 7 | 4 | 59 | 40 | |||
| 60200 | 205759 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 158 Stillings Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 5999706.25726 | 2095793.86202 | 37.7346334171983 | -122.443439244924 | (37.7346334171983, -122.443439244924) | 9 | 7 | 4 | 63 | 40 | |||
| 60527 | 205792 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 266 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5999651.949 | 2094386.03565 | 37.7307647585665 | -122.443525909907 | (37.7307647585665, -122.443525909907) | 9 | 7 | 4 | 63 | 40 | |||
| 60554 | 205855 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 289 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994148.42525 | 2089316.11897 | 37.7165285859025 | -122.462184770318 | (37.7165285859025, -122.462184770318) | 9 | 8 | 6 | 28861 | 24 | |||
| 60678 | 175733 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1183 Munich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6001131.65449 | 2087116.65406 | 37.710888955334 | -122.437889869445 | (37.710888955334, -122.437889869445) | 9 | 7 | 6 | 28861 | 5 | |||
| 60796 | 205803 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 360 Flood Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998365.05291 | 2094110.50615 | 37.7299347427897 | -122.447955063785 | (37.7299347427897, -122.447955063785) | 9 | 7 | 4 | 28861 | 40 | |||
| 60805 | 175600 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 626 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6002200.33228 | 2090264.59279 | 37.7195932128426 | -122.434421197784 | (37.7195932128426, -122.434421197784) | 9 | 7 | 6 | 28861 | 5 | |||
| 61271 | 111727 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 158 MAYWOOD DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | 5994266 | 2095568 | 37.7337015061884 | -122.462231535938 | (37.7337015061884, -122.462231535938) | 9 | 8 | 4 | 59 | 40 | ||||
| 61856 | 175744 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 46 Baltimore Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6003028.75595 | 2086646.47615 | 37.7097056462618 | -122.431299507078 | (37.7097056462618, -122.431299507078) | 9 | 7 | 6 | 28861 | 5 | |||
| 61914 | 205829 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 122 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995652.85009 | 2090722.80681 | 37.7204775260872 | -122.457086459674 | (37.7204775260872, -122.457086459674) | 9 | 8 | 6 | 28861 | 24 | |||
| 62503 | 175635 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 29 Tucker Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010977.99062 | 2088484.11586 | 37.7151987323072 | -122.403954615717 | (37.7151987323072, -122.403954615717) | 9 | 7 | 8 | 309 | 39 | |||
| 63105 | 175748 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 66 Baltimore Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002940.94851 | 2086563.0179 | 37.7094715113586 | -122.431597030685 | (37.7094715113586, -122.431597030685) | 9 | 7 | 6 | 28861 | 5 | |||
| 63251 | 175693 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 787 Burrows St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6009201.76364 | 2092855.14224 | 37.7271012595966 | -122.410402506577 | (37.7271012595966, -122.410402506577) | 9 | 3 | 7 | 309 | 28 | |||
| 63343 | 175683 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Valmar Ter | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6005492.68833 | 2092982.27717 | 37.7272417193178 | -122.42323378172 | (37.7272417193178, -122.42323378172) | 9 | 7 | 6 | 28861 | 5 | |||
| 63430 | 175702 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 143 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6006611.11425 | 2093770.55631 | 37.7294692177261 | -122.419423281381 | (37.7294692177261, -122.419423281381) | 9 | 3 | 7 | 309 | 28 | |||
| 64242 | 204560 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 54 | Median : Cutout | Tree | DPW 1 | 16 | Width 5ft | 5999598.12734 | 2097466.83361 | 37.7392208346642 | -122.443933247029 | (37.7392208346642, -122.443933247029) | 9 | 7 | 4 | 59 | 40 | |||
| 64368 | 31112 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 415 Edna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1995 12:00:00 AM | Permit Number 34838 | 5998740.33351858 | 2094135.45298345 | 37.7300246851321 | -122.446659473393 | (37.7300246851321, -122.446659473393) | 9 | 7 | 4 | 28861 | 40 | |||
| 64668 | 175698 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 206 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007171.17562 | 2092665.22194 | 37.7264657375013 | -122.417408787407 | (37.7264657375013, -122.417408787407) | 9 | 3 | 7 | 309 | 28 | |||
| 64701 | 204527 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 31 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 5999174.36675 | 2097015.29768 | 37.737956842928 | -122.445365957891 | (37.737956842928, -122.445365957891) | 9 | 7 | 4 | 59 | 40 | |||
| 64716 | 175643 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 275 De Long St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 10ft | 5993719.91168 | 2086800.30724 | 37.7095960827685 | -122.463483442609 | (37.7095960827685, -122.463483442609) | 9 | 8 | 6 | 28861 | 25 | |||
| 64812 | 175682 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1623 Silliman St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 2ft | 6006040.0348 | 2092856.83897 | 37.7269281679874 | -122.421332701253 | (37.7269281679874, -122.421332701253) | 9 | 7 | 7 | 309 | 5 | |||
| 65258 | 175664 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 221 Craut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004059.52625 | 2093913.94883 | 37.7297188964874 | -122.428254586081 | (37.7297188964874, -122.428254586081) | 9 | 7 | 6 | 28861 | 5 | |||
| 65675 | 43164 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 243 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 7 | Permit Number 42974 | 6005687.81247 | 2092539.35146 | 37.7260365522386 | -122.42252777796 | (37.7260365522386, -122.42252777796) | 9 | 7 | 7 | 309 | 5 | |
| 65817 | 204360 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 160 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5992214.92072 | 2088927.28507 | 37.7153494245261 | -122.46883958168 | (37.7153494245261, -122.46883958168) | 9 | 8 | 6 | 64 | 24 | |||
| 65909 | 204358 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 374 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5991983.82483 | 2090975.49308 | 37.7209599503178 | -122.469787374484 | (37.7209599503178, -122.469787374484) | 9 | 8 | 6 | 64 | 24 | |||
| 66009 | 204514 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 439 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997418.29504 | 2097239.38881 | 37.7384717416823 | -122.451453690035 | (37.7384717416823, -122.451453690035) | 9 | 7 | 4 | 59 | 40 | |||
| 66203 | 175641 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 275 De Long St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 10ft | 5993718.84188 | 2086795.50483 | 37.709582834847 | -122.463486791709 | (37.709582834847, -122.463486791709) | 9 | 8 | 6 | 28861 | 25 | |||
| 66943 | 114662 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 480 Myra Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5997245.35324946 | 2096954.8836892 | 37.737680654694 | -122.452031115145 | (37.737680654694, -122.452031115145) | 9 | 7 | 4 | 59 | 40 | |||
| 67043 | 204547 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 68 | Median : Cutout | Tree | DPW 1 | 15 | Width 5ft | 5999723.97514 | 2097336.19746 | 37.7388693166702 | -122.443488741839 | (37.7388693166702, -122.443488741839) | 9 | 7 | 4 | 59 | 40 | |||
| 67310 | 205732 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 326 San Benito Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992852.62159 | 2094635.50509 | 37.731059623795 | -122.467050187134 | (37.731059623795, -122.467050187134) | 9 | 8 | 4 | 59 | 40 | |||
| 67707 | 204382 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 41 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 4 | 5992173.48186 | 2088232.60675 | 37.7134396116198 | -122.46893228742 | (37.7134396116198, -122.46893228742) | 9 | 8 | 6 | 64 | 24 | ||||
| 68454 | 175672 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 230 Craut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004030.40856 | 2093836.80851 | 37.7295054388182 | -122.428349753264 | (37.7295054388182, -122.428349753264) | 9 | 7 | 6 | 28861 | 5 | |||
| 68826 | 42991 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Yale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42870 | 6007553.67502493 | 2091408.33369541 | 37.7230361052022 | -122.415997529963 | (37.7230361052022, -122.415997529963) | 9 | 3 | 7 | 309 | 28 | ||
| 68944 | 49893 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6@ OCEAN Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50572 | 5993153.17842145 | 2093093.53426236 | 37.7268430955942 | -122.46589912079 | (37.7268430955942, -122.46589912079) | 9 | 8 | 4 | 59 | 40 | ||
| 70072 | 175589 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 591 Brunswick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5999000.75807 | 2086779.04267 | 37.7098405454782 | -122.44523046062 | (37.7098405454782, -122.44523046062) | 9 | 7 | 6 | 28861 | 5 | |||
| 70387 | 205817 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 112 Marston Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5998664.62429 | 2093222.76421 | 37.7275143308076 | -122.446855559853 | (37.7275143308076, -122.446855559853) | 9 | 7 | 4 | 28861 | 40 | ||||
| 70562 | 204589 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 359 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5997724.27189 | 2095500.4152 | 37.7337144539423 | -122.450270459239 | (37.7337144539423, -122.450270459239) | 9 | 7 | 4 | 59 | 40 | |||
| 71124 | 205850 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 438 Orizaba Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5994044.85216 | 2089294.81203 | 37.7164641180118 | -122.462541222916 | (37.7164641180118, -122.462541222916) | 9 | 8 | 6 | 28861 | 24 | |||
| 71180 | 69438 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Santa Cruz Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1994 12:00:00 AM | 6 | Permit Number 33545 | 5993088.80201 | 2086544.97974 | 37.7088586314964 | -122.465646111595 | (37.7088586314964, -122.465646111595) | 9 | 8 | 6 | 28861 | 25 | ||
| 71426 | 204535 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 13 | Median : Cutout | Tree | DPW 1 | 9 | Width 3ft | 5999462.01157 | 2097038.1578 | 37.7380360273359 | -122.444373073979 | (37.7380360273359, -122.444373073979) | 9 | 7 | 4 | 59 | 40 | |||
| 71880 | 175646 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 275 De Long St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 10ft | 5993722.89868 | 2086804.10451 | 37.7096066812751 | -122.463473394488 | (37.7096066812751, -122.463473394488) | 9 | 8 | 6 | 28861 | 25 | |||
| 72021 | 42345 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
| 72258 | 175663 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 279 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6004167.57831 | 2091788.97254 | 37.7238902967841 | -122.427729693185 | (37.7238902967841, -122.427729693185) | 9 | 7 | 6 | 28861 | 5 | ||||
| 72664 | 24269 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300X Winding Way | 7 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6001399.20674 | 2086458.92155 | 37.7090981776115 | -122.43691809172 | (37.7090981776115, -122.43691809172) | 9 | 7 | 6 | 28861 | 5 | |||
| 72837 | 116686 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002102.67453 | 2092656.42028 | 37.7261550900614 | -122.43492972844 | (37.7261550900614, -122.43492972844) | 9 | 7 | 6 | 28861 | 25 |
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) );